access question

[spsmcc]

k, i want to create a databaset that lets me input names and then assign them a number like 00459724 or something. But, I only want that number to be assigned to that person and nobody else, i would also like to make sure that after x time the number expires and is removed from the name, or the database prints out a report and i manually remove the number from the name, can anybody point me in the right direction?

ps im a newbie

 

[RichardJ]

Theres a few parts to this request....

Firstly

Create your ID field in your table and set the Indexed property of the field to "Yes (No Duplicates)" this then stops a number being entered twice.

You can also set the number to "Autonumber". Access will then generate a new number for every new record you enter. These can either be concurrent or not, your choice.

As for removing the numbers after x amount of time, why would you do that? For audit purposes, and as these numbers are never to be repeated would it not be better to hide the number once x time has passed. This could be done by recording the date and time of the record entry and checking this once x time has passed.

JHope those ideas help