Fill a Form From a Product ID

Hi I am looking for a quick and easy way to fill form details from a product ID 

Example: Product ID comes from a reference table 

I want the corresponding information to match from the two tables 

Database:           Form:

Unit Price :     Unit Price 

Tax :Tax  

Description : Description 

 

Would this be a select formula ?? Please let me know. 

 

Thanks,

Brendan 

0 9 215
9 REPLIES 9
Top Labels in this Space