I have a table which has 4000 records of unique numbers. I added a field called "used" which is a Yes/No as well as a field called number where each record is numbered from 1 to 4000. I have a form for another table with many records. When I create a new record, the first thing I would like to do is write code which will take the first record which has used set to No from the first table and insert this into my form and then update that record from No to Yes.
Would someone be able to help me with this?
Thanks,
Sam