Problems with Table relationships

[jimoharry]

Hey

I was wondering that is it possible that is in one field I select a certain name, say a type of product and that in another field will automatically display the price of that product based on another table.

Thanks

 

[gemma-the-husky]

either base your table on a QUERY that joins the product and prices tables, and then the prices will be reasdily available with no further work

or - after you pixk a product do a dlookup to find the price