By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,578 Members | 828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,578 IT Pros & Developers. It's quick & easy.

Choosing more than one selection in a list box

P: n/a
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.

Jul 18 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

--
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**********************@h48g2000cwc.googlegr oups.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.

Jul 18 '06 #2

P: n/a
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.

--
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**********************@h48g2000cwc.googlegr oups.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.
Jul 18 '06 #3

P: n/a
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.

Jul 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.