Hi all,
I am having problem with linking two tables. Here is an example:
Orders table
-------------
OrderId (autonumber)
Description
SupplierID (Number)
Supplier Table
----------------
SupplierID (autonumber)
Description
I then link both the tables together which just work fine. (one to Many as the relationship)
In Design mode in the Orders Table I then choose SupplierID field as a combo box and have the following code as the row source : SELECT DISTINCTROW supplierID, Description FROM supplier
However upon entering Data in the ORDERS table, when clicking on the supplierID fields it shows the numbers instead of the description. I have review the NorthWind example of the database and everything seems to be the same. What am I doing wrong?? ANy advice is much appreciated.
Thanks
I am having problem with linking two tables. Here is an example:
Orders table
-------------
OrderId (autonumber)
Description
SupplierID (Number)
Supplier Table
----------------
SupplierID (autonumber)
Description
I then link both the tables together which just work fine. (one to Many as the relationship)
In Design mode in the Orders Table I then choose SupplierID field as a combo box and have the following code as the row source : SELECT DISTINCTROW supplierID, Description FROM supplier
However upon entering Data in the ORDERS table, when clicking on the supplierID fields it shows the numbers instead of the description. I have review the NorthWind example of the database and everything seems to be the same. What am I doing wrong?? ANy advice is much appreciated.
Thanks