I used Analyze Table to split a table into three tables Table2, Customer, and Shipment. Both the Customer and Shipment tables have an autonumber Primary Key (PK) field assigned (CustomerID & ShipmentID respectively). Table 2 is linked to these tables via Foreign Key (FK) fields CustomerID & ShipmentID (Same names as PK in the associated table). The display control is a combo box for these two fields.
When I open Table2 in datasheet view, both of the FK fields contain what appears to be the data from the multiple fields contained in the associated PK table. I was expecting to see just the PK (as a number) rather than the data.
I do see that Row Source for the field has code
If I delete this code, the PK reference number appears to show up leaving me a couple questions:
Thank you for the help and insight.
When I open Table2 in datasheet view, both of the FK fields contain what appears to be the data from the multiple fields contained in the associated PK table. I was expecting to see just the PK (as a number) rather than the data.
I do see that Row Source for the field has code
SELECT [ShipID] AS xyz_ID_xyz, [Tracking_Info] & ', ' & [Shipdate] AS xyz_DispExpr_xyz, [Tracking_Info], [Shipdate] FROM Shipments ORDER BY [Tracking_Info], [Shipdate];
If I delete this code, the PK reference number appears to show up leaving me a couple questions:
- Is this normal or did I set something up incorrectly?
- If this code remains, am I storing duplicate data from the other tables in the Table2 fields?
- Is this code necessary to maintain data integrity?
Thank you for the help and insight.