How do I store data from synchronized combo boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top