Create options field 1

[germain2]

Any ideas on the best way to create an option field that allows the choice of more than one answer for a field. Thanks

 

[Remou]

A listbox can be set to Multiselect. However, are you sure that you wish to store more than one value in one field?

 

[germain2]

Remou
Thanks for your response on the options, what would you recommend doing if faced with this dilemma:
I want a field called Program Type: to allow people to select a any of 5 programs. So if someone picks two programs as the answer, how should it be stored/ thanks

 

[Remou]

In another table.

[tt]tblMain
MainID -> Primary Key
Etc

tblProgramme
ProgID -> Primary Key
Etc

tblMainProgs
MainProgID (Optional Primary Key)
MainID Fk ( These can be combined to create a
ProgID Fk ( Primary key[/tt]

You will wish to read

http://www.r937.com/relational.html