setting up a relationship with two tables

  • Thread starter Thread starter ann smith
  • Start date Start date
A

ann smith

I'm creating a drop down menu list in forms. I want the info in the drop
down menu to come from two small tables.

One table is called "Small Computer" and the other table is called "Big
Computer". In each table, there's information regarding each computer type.
When an end user clicks on the drop down menu, they should be able to see
Small Computer and Big Computer. What kind of relationship do I have to
setup to make this happen? Thanks for any help in advance.
 
I'm creating a drop down menu list in forms. I want the info in the drop
down menu to come from two small tables.

One table is called "Small Computer" and the other table is called "Big
Computer". In each table, there's information regarding each computer type.
When an end user clicks on the drop down menu, they should be able to see
Small Computer and Big Computer. What kind of relationship do I have to
setup to make this happen? Thanks for any help in advance.
Click to expand...

I'm not sure quite what you want to see. If there are (say) twenty
records in the Small Computer table, and ten in Big Computer, and you
want the combo box to show all thirty choices, a UNION query would be
appropriate. You need to go to the SQL window to create this; see the
online help for UNION.

If that's not what you have in mind, please post a bit more
description of these two tables and what you would like the combo box
to show.
 
Back
Top