How do I store data from synchronized combo boxes?

[Guest]

I am trying to create synchronized combo boxes and store the text in a
seperate table. Much like
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

The only problem is when I try to store the values in my table, all I get
are the primary key id's, instead of the text. Any ideas on what I'm doing
wrong?

 

[Guest]

Hi, Blenk.

It is, in general, undesirable to store the text because doing so would
violate table Normalization rules--you normally store only a numeric foreign
key, and get the text whenever you need it through a query that links the two
tables. For example, what if the text needed to be changed for some legal or
marketing reason? If you save text, you will need to change every record
that has that value, rather than just once.

There are, however, exceptions, and your situation may be one of them. If
that's the case, set the ControlSource of the combo box to your text field,
include the text description in the RowSource query statement, and set the
BoundColumn property to the column that holds the description (numbered
starting with 1).

Hope that helps.

Sprinks