Suggest number based on already used numbers

[Patience]

Hi guys,

Here is the set-up:

I have a field A in which the user enters a number. This number will be identical for many related posts created by the user. It is an identification number that shows which posts are related.

When the user needs a new number for a group of related posts, I would like Access to suggest an available number; that is a number which has not already been used.

Do you have an idea of how this can be easily done?

thank you very much!

[maximus]

Check Autonumeber. Make the Field Type Autonumber that will generate this Number.

Advantages:
No VBA Codes Required
Disadvantage:
Not Good if you want to maintain sequence.

if you are not bothered about the sequence of you numbers thne go a head otherwise you have to opt for other methods just let me know.

[Patience]

Thanks maximus.

However, autonumber generates a new number for each post. I would like to be able to use the same number for several posts. Is that possible?

[maximus]

try a One-Many Relationships. create two tables one which has the field which will have the unique number. Next table will have a foreign key which is linked to the main table. here you will the data.