How 2 store mutli combo box values into separate table columns

[Guest]

IS it possible to split out mulitple combo values into separate columns (in
the same table)?

Many thanks in advance

 

[John Vinson]

IS it possible to split out mulitple combo values into separate columns (in
the same table)?

Many thanks in advance

You can *display* multiple columns' values on a Form with textboxes
with control source

=comboboxname.Column(n)

where n is the zero based index of the column.

However, storing these values redundantly in a second table is
generally not a good idea.

John W. Vinson[MVP]

 

[Guest]

Thnaks John - Sorry I musn't have been clear in my request. I'm displaying
multiple values from one table in my database but I need to store these
multiple values (once selected by the user) in another (related) database
table. Is this possible? If so how?

Many thanks

Nick

 

[John Vinson]

Thnaks John - Sorry I musn't have been clear in my request. I'm displaying
multiple values from one table in my database but I need to store these
multiple values (once selected by the user) in another (related) database
table. Is this possible? If so how?

Why?

Storing data redundantly is almost NEVER either necessary or prudent.
It wastes space; more importantly, it means that you have all that
many more places to track down and edit if any of the data ever
changes.

You're using a relational database. Use it relationally! Store the
data ONCE, and only once; then use Queries joining the tables to view
the data in related tables whenever needed.

If you have some GOOD reason to copy the data into a second table
please explain. It can be done - it's just that it generally should
NOT be done.

John W. Vinson[MVP]