Combo Box Without Foreign Key?

[dbrooks]

Anytime in the past when I had a option in the database about sex of a person, (like Female or Male), I would create a table called "SEX" then put male or female in as a foreign key to the main table.

Is this better then just using the option of a value list and a text box within the same table? I just noticed that if I make this column a combo box intead of a text box (but format it as text) I can use a value list. In the value list I can put Male; Female. Then I will have my two choices. Why would I not want to use this?

If anyone knows for certain please let me know. Thanks very much. -db

 

[jfgambit]

Pat:

I just wanted to say that as usual, you have proven yourself an access guru.

I'm always impressed by your answers, and wanted to get the extra post number...he he

BTW...do you ever sleep?

 

[dbrooks]

Pat,
Thanks for your response. You have always been a great help with all of my questions. I think you are right I would want to go with Tables, however if I just have two possible choices like "Male";"Female" this would probably work with a value list, correct? I am going to continue using tables, unless I get your opinion on a situation like "Male";"Female".

Thanks very much.

-db