No, that's not right either.
If you are storing people's choice of colors, you will have:
Person table, with PersonID as primary key.
Color table, with ColorID as primary key
PersonColor table, to store the preferences:
PersonID relates to Person.PersonID
ColorID relates to Color.ColorID
If a person likes 5 colors, they have 5 entries in the PersonColor table.
For another example, see:
Relationships between Tables (School Grades example)
at:
http://allenbrowne.com/casu-06.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<pe******@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
Allen thanks,
Can I create a different table with several fields
field1
field2
field3
etc...
according to how many options I have in the "List box" ?
my question would be: how to set my fields on my table as a text or
memo?
what would be my key in this new table?
thank you again..
Allen Browne wrote:
>Create a related table, where you store the multiple selections as
multiple
related records.
You do not ever put multiple different values all into one field, or in
multiple different fields in the one table.
<pe******@gmail.comwrote in message
news:11**********************@h48g2000cwc.googleg roups.com...
Hi guys, I know that I can select more than one option using a list box
by changing tha multi select option to simple or extended BUT,
How do I have to design my field on my table?
I have tried to use it in a form to select more than one room and I am
able to selected but seem like if doesnt record my selection.
I hope you all can help me.
