How do you autocreate id's

[Jak82]

Hi,

I have a query which reads in data from a sql server database, I then want to add a checkbox to say if people have been emailed.

I have created another table which contains autoid and 'emailed' the emailed is a checkbox which once I run the query seems deactive. How do I linked the autoid from the emailed table to the main table, I have tried creating a link in the relationship but that doesnt seem to populate the table.

Any ideas?

 

[GinaWhipp]

I don't understand, why did you put the field in a table all by itself? Why not put in the same table and set it to yes once the eMail has been sent.