automatically assign numbers

[gvh]

I am very new to database building.



I need to create a registeration database for a shooting sport competiton event that can either automatically assign each new registerant a target number when they are entered into the database, or allow me to enter different number if I wish.

Any help would be greatly appreciated. Thank you in advance

[mejia.j88]

is there a limit to the list of target numbers?

[gvh]

yes there is. might vary from tournament to tournament

[mejia.j88]

im assuming that in your form there are fields for the participant's information, and there should be a field for the target number they are assigned?