I have a table called tblDocuments and within that table there is a field named DocumentNumber. I would like the Document Number to be a random 6 digit number that is not already in the table. I was thinking I should use a Loop with a DLookup inside but i'm not sure how to write that and I didn't find anything helpful on the internet. Thoughts?
Aucun commentaire:
Enregistrer un commentaire