Question Getting Values from Table2 based on value selected in Table1

[murtazakhambaty]

Hello..

I have a table named Product and Quotation.

This is what i want to achieve

In Table Quotation when i select product name from dropdown menu i want all the related information for that product to be visible in Quotation like product id, productdescription & productcost

Can anyone please help?

 

[madefemere]

Hello,

If you want theses informations only in your combobox, you can adjust the number of column of the combo and their width.
And if you want they are visible in the Quotation's form, Look at the help of the "Column" propriety of an combobox.
I think you can't do it in a table.

Good continuation

 

[jorel]

Do you want it to happen in your table or in your form?