G
Guest
I have two tables that are related. The second table has a many to one
relationship with the first. In case I worded that wrong, the first table can
have many records in the second table, but each record in the second table is
only related to one record in the first.
In design view and relationships view, the linked field is visible. When I
open the linked second table, the first table's linked field does not appear.
In other words:
Design View for 2nd Table
Contract Auto-number, Primary key
Company Number
Date Date
(etc.)
Table view:
Contract Date (etc.)
Why doesn't the one field show? The other fields all do. Thank you.
relationship with the first. In case I worded that wrong, the first table can
have many records in the second table, but each record in the second table is
only related to one record in the first.
In design view and relationships view, the linked field is visible. When I
open the linked second table, the first table's linked field does not appear.
In other words:
Design View for 2nd Table
Contract Auto-number, Primary key
Company Number
Date Date
(etc.)
Table view:
Contract Date (etc.)
Why doesn't the one field show? The other fields all do. Thank you.