Available Numbers

[caykamanj1966]

All, I have a field called: available_numbers.

I would have a block of numbers from: 1001 thru 1010.

I want to be able to have a those blocks of numbers entered somewhere (i guess another table), not sure where they should be stored.

So if number 1002 is already taken and someone tries to enter 1002 in the available_number field, the database would alert them that the number is already used.

I would love to input all the numbers that can be used in a table, and the database would keep track of the numbers that are used and will not let anyone choose those numbers.

How can something like this be accomplished?

 

[dhookom]

Create your table of numbers and use the unmatched query wizard to create the row source of a combo box to select the available numbers.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016