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.
<pedro8ae@gmail.comwrote in message
news:1153236402.155612.310730@m73g2000cwd.googlegr oups.com...
Quote:
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:
Quote:
>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.
>>
><pedro8ae@gmail.comwrote in message
>news:1153234611.300677.219010@h48g2000cwc.googleg roups.com...
Quote:
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.
