got_access:]
Registered User.
- Local time
- Today, 07:29
- Joined
- Jun 15, 2018
- Messages
- 83
Hi All,
I have a sample db for learning purposes.
It has 3 tables.
Customer
Orders
Products
The Customer table has a CustomerID field and it also has a "CompanyName" field
The Orders table also has a CustomerID field which is used to link to the Customer table.
The strange thing is - when I look at the Orders table in data-sheet view, all of the values that are populated within Orders.CustomerID are not displayed as the Customers.CustomerID values. What is displayed as Orders.CustomerID is in fact the "CompanyName" values from the Customers table.
I assume the person who set this db up must have set some option within Access to make it display the "CompanyName" rather than the "CustomerID" values.
There is nothing setup within the "caption" option of this field in the Orders table.
So I can't figure out what option does that?
Thanks in advance
I have a sample db for learning purposes.
It has 3 tables.
Customer
Orders
Products
The Customer table has a CustomerID field and it also has a "CompanyName" field
The Orders table also has a CustomerID field which is used to link to the Customer table.
The strange thing is - when I look at the Orders table in data-sheet view, all of the values that are populated within Orders.CustomerID are not displayed as the Customers.CustomerID values. What is displayed as Orders.CustomerID is in fact the "CompanyName" values from the Customers table.
I assume the person who set this db up must have set some option within Access to make it display the "CompanyName" rather than the "CustomerID" values.
There is nothing setup within the "caption" option of this field in the Orders table.
So I can't figure out what option does that?
Thanks in advance