please help

  • Thread starter Thread starter rkhart
  • Start date Start date
R

rkhart

I have just begun using this program.. I have created 2 tables and
formed a relationship between them. I have identified the primary key
as the ID. I would like to have a drop down colum in my table in which
I can click the + and infformation from the other table will appear.
please help me i would greatly appreciate any assistance
thank you
 
I have just begun using this program.. I have created 2 tables and
formed a relationship between them. I have identified the primary key
as the ID. I would like to have a drop down colum in my table in which
I can click the + and infformation from the other table will appear.
please help me i would greatly appreciate any assistance
thank you
Click to expand...

Ummm...

No. You really DON'T want to do this.

Tables are for *data storage*. They are *not* designed for data
display or editing, and should be used only for debugging.

Instead, create a Form to do this. You can use the form wizard if you
wish; select both tables, and you'll get the option to have a Form
with a Subform which will display one record from the "one" side table
and all the matching records from the "many".

If you have the same field as the Primary Key in both tables, though,
you may be on the wrong track - one to one relationships like this are
rather rare; one-to-many relationships are much more typical. What
real-world entities do these two tables represent?

John W. Vinson[MVP]
 
Back
Top