using a combo box to update several fields in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several fields in a table (stock number, description, Etc). I'm
trying to use a combo box to select the stock number on a form, but it needs
to update the other fields in the table when the number is selected. I'm
definately not a programmer so please keep it as simple as possible for me.
Thanks
 
On Sat, 26 Feb 2005 14:01:02 -0800, "Southern Exposure" <Southern
I have several fields in a table (stock number, description, Etc). I'm
trying to use a combo box to select the stock number on a form, but it needs
to update the other fields in the table when the number is selected. I'm
definately not a programmer so please keep it as simple as possible for me.
Thanks
Click to expand...

Well... Don't.

A basic principle of relational database design is what I call the
"Grandmother's Pantry Principle" - "a place - ONE place! - for
everything, everything in its place". If you have a Stock table with
the description, etc. then that information should be stored *ONLY* in
that table. If you have a (say) sales table, it should contain only
the stock number, and nothing else from the stock table.

You can create a Query linking the tables to display the stock
information in conjunction with the other table's information; or you
can put unbound Textboxes on a form to *display* the data. Set their
control source properties to

=cboStock.Column(n)

where cboStock is the name of the combo and (n) is the *zero based*
subscript of the query upon which the combo is based.

John W. Vinson[MVP]
 
Back
Top