0

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.

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by Sally123
0

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.

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.