I have two tables as below
table 1
ProductID---Int
Descritption---Text
table 2
Id
FK_ProductID--Int
Category
but on the FK_ProductID I dont want my table not to display a number but the description from TBLA.
I have two tables as below
table 1
ProductID---Int
Descritption---Text
table 2
Id
FK_ProductID--Int
Category
but on the FK_ProductID I dont want my table not to display a number but the description from TBLA.
1) Open table 2 in design view
2) Click on the FK_ProductID field
3) Click on the Lookup Tab (next to the General tab that lists the properties of the field)
4) Make sure Display Control is set to Combo Box
5) Change the row Source to table 1
6) Change Column cout to 2
7) Change Column widths to 0";1"
When you view the table in datasheet view, the field will now be a dropdown box with the second field in table 1 as its options.
1) Open table 2 in design view
2) Click on the FK_ProductID field
3) Click on the Lookup Tab (next to the General tab that lists the properties of the field)
4) Make sure Display Control is set to Combo Box
5) Change the row Source to table 1
6) Change Column cout to 2
7) Change Column widths to 0";1"When you view the table in datasheet view, the field will now be a dropdown box with the second field in table 1 as its options.
Thanks a million
It works perfect.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.