G
Guest
I have one table that lists every Shipper/Consignee my company deals with,
which provides address, phone number, etc.
I first created separate Shipper and Consignee tables to uniquely refer to
each record in another table using a primary key record ID. This is stupid
though since the data within each Shipper and Consignee table is identical.
How can I use one reference table and still be able to uniquely identify the
Shipper and Consignee, even though Shipper = Consignee in that reference
table?
which provides address, phone number, etc.
I first created separate Shipper and Consignee tables to uniquely refer to
each record in another table using a primary key record ID. This is stupid
though since the data within each Shipper and Consignee table is identical.
How can I use one reference table and still be able to uniquely identify the
Shipper and Consignee, even though Shipper = Consignee in that reference
table?