Column Issue (new to sql)::: Probably Real Easy

[lcbigham]

Hopefully this is the right forum. This is my first time here. I have a sql database that has a members table with fname,lname,password,email address and directors code. I would like to have when the person goes to fill out the signup form it makes sure that the directors code they enter exist. Any help would be greatly appreciated.

 

[AlexCuse]

Do you have a 'lookup table' that will contain all allowed director codes?

If so, you may want to use a check constraint?

I'm still not clear on what you need though, can you show some examples?

Also, as you say you are new, this may be a good read for you: faq183-874

It will help you ask questions in a way that will get you a quick, accurate answer.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SQLSister]

Personally I would make the code data entry on the form a pull down box and have the list be limited to only the entries inthe table where the codes are stored.

Questions about posting. See faq183-874