Incremental / Re useable Unique ID's

[NikC]

Hello All

1st off all let me appologies if this has been asked 100's of times b4 or if its a question thats covered in the access help files ..... i have tried searching but cant seem to find anything specific to my issue.

What i have is a very basic access memeber ship db that i would like to add a unique auto generated Member Ship ID to (i thought Auto Number Would do but as i found it doesnt).

Theres never going to be more than 500 records in the db and if possible i would like to be able to recycle old numbers when memebers are deleted.

Is there any simple way i can do this ?

Many Thanks

NikC

 

[NikC]

If i was to want to recycle them though ..... is it possible with not "too" much code ?

 

[samcoinc]

I have actually done this. We have a die inventory that need to reuse dienumbers becouse of space problems. say we have 4000 dies. I made a table of sequential numbers(1 to 4000) that I link up with the die table. It is linked up in a query showing all the seq numbers and only the die numbers that match up. Then I only show the die numbers that are null becouse they are deleted out of the die table. The first number in the seq column reusable number. I hope this makes sense.

sam