Field Values

[Banditmom]

: Can someone Pleeeease help me? I have created a database for a car show. In one of the fields I want to be able to put the space # on the blvd. I got that! Now what I want is to NOT assign that space to any other person, and I REALLY don't want to use a value list because there are over 350 spaces!!! For example...If I add John Smith space #369...I don't want to be able to give anyone else space #369. If I give them that space # I want that field to NOT accept it. Is this possible and how do I do it if it is?:

I have taught myself how to use this program so I don't know a whole lot. But I would be soooooo greatful for any help!

[Raybaudi]

Hi

you could check the validation options for that field and set it to be unique.

[Lee Smith]

Hi Banditmom, and welcome to the forum.

over 350 spaces!!! For example...If I add John Smith space #369...I don't want to be able to give anyone else space #369.

How often do these spaces turnover. Unless these are burial plots, I would expect that these spots are going to turn over.

Take a look at Bookings system by Ray Cologon at Nightwing Link

HTH

Lee

[Banditmom]

Thank you for your response. LOL no they are not burial plots but we only do this once a year...so it would stay in place for an entire year. It sounds like my best solution is going to be the value list...but it will still allow me to put it in multiple times. Thanks again for your help and I'm going to try your link!

[Banditmom]

:clap: Thank you for your response! I tried your suggestions and that was what I was looking for. Thank you soooooo much for the simple solution!

:yourock: