Question Tables

[dsthome]

If I have 3 tables linked together is it possible when I put a product code in one of the tables it will lookup my product table and return the description in a description field on my orders table.? So far I can only get it to give me a lookup with a list of all the product codes for me to choose from.

Thanks

 

[pr2-eugin]

dsthome, It might not be something that can be done on a table level.. But most defenitely on a Form level.. However that would be more of a Calculated field, whihc does not necessarily be required to store in the table.. They can be displayed when and where it is required, by means of Queries and Unbound Form controls..

I know this might not be the answer you are looking for, but this is the way you should go.. Lookups in Table are EVIL.. Storing calculated Values are not right..