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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.