Viewing fields in a one to many relationship

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have two tables linked on a one to many relationship table. When I go into
the "one" table with the primary key field it has the little plus boxes on
the left to view the data from the "many" table with the foreign key.
However, when I click on that box, all it shows me is the same data that is
in my "one" table. How do I view the fields that are in the "many" table
that are not in the "one" table?

To put it in perspective, I have an invoice number that is coded to 3
different account numbers. The invoice number is my primary key field in the
"one" table and is linked on invoice number to the "many" table. When I
click on that plus box, I want to be able to view the 3 different account
numbers without having to always go back to the “many†table and manually
look up the invoice number.
 
Instead of working in the tables directly, you might want to consider
creating a form/subform on these two tables. (There's a wizard that will
walk you through it.) The main form will be based on the "one-side" table
and the subform on the "many-side" table.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Jason said:
I have two tables linked on a one to many relationship table. When I go
into
the "one" table with the primary key field it has the little plus boxes on
the left to view the data from the "many" table with the foreign key.
However, when I click on that box, all it shows me is the same data that
is
in my "one" table. How do I view the fields that are in the "many" table
that are not in the "one" table?

To put it in perspective, I have an invoice number that is coded to 3
different account numbers. The invoice number is my primary key field in
the
"one" table and is linked on invoice number to the "many" table. When I
click on that plus box, I want to be able to view the 3 different account
numbers without having to always go back to the “many†table and
manually
look up the invoice number.
Click to expand...
 
Back
Top