One form duplicate data

[Banderas23]

Hi,

Step 1. I have a database with 2 forms and 2 tables and tables have 20 fields. One of the fields is a yes/no checkbox.

When clicking save record button on form 1, I want it to save a copy of all the data into table 1, and into table 2 If the yes/no checkbox is set to yes.

Table 1 and 2 are identical in fields.

step 2 in my project is, I have a search function(form 2) to bring up data from table 2. This allows me to see all the entries that need an email sending to them. From the yes/no confirmation box in form1. I have a search form that searches table 2 and shows me to send emails to certain clients.

I need a way of when an email has sent, the client is removed from table 2.

If you can point me in the right direction or offer some help with the code is be much appreciated.

I can send my database to anyone who may want to take a look and help with my project.

Thanks in advance

Antony

 

[Galaxiom]

Your plan is heading in completely the wrong direction. Search for information about database normalization before you go any further.

 

[Banderas23]

Had a read and found a much simpler way to do this. Cheers. I am a proper noob.

 

[Galaxiom]

I am a proper noob.

Not quite, now that you know about Normalization.