Combo Box

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

Guest

I have 2 tables one for products {productID as Prim. Key} and a Sales table, they are associated with one to many link at the productId, the question is thati need to have a form to enter Sales but instead of selecting the productId numbers i need to select their names any idea how i can do this
thank you fro your tim
Sotiris_s
 
I have 2 tables one for products {productID as Prim. Key} and a Sales table, they are associated with one to many link at the productId, the question is thati need to have a form to enter Sales but instead of selecting the productId numbers i need to select their names any idea how i can do this?
Click to expand...

Use the ProductID as the "bound column" of the combo, but the product
name as the first visible column. The COmbo Box Wizard will set this
up for you automatically, just click the magic wand icon on the
toolbar, add a combo box to the Form, and follow the instructions.
 
thank you that realy solved the problem at a glance... i thought that i had manually selected the same method but with the help of the wizard it all come clear
thank yuo for the Ultra fast Responce it's great that people want to sare their knowledge
sotiris_s
 
Back
Top