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

 

[DavidAtWork]

can you post the related tables and relevant fieldnames, and state at what point in the dataflow do you want to update the description field.

David

 

[dsthome]

Please find attached the Databse I have started this morning very much a work in progress, and very much new to databse design. I may be going completely down the wrong route please advise. I have a table for orders and a table for products, I am trying to get it so when you put the item code in the order table it bring up all the other information from the products table description, type, spec, gross, nett and vat

Thanks

 

[jdraw]

You should research Normalization. Your tables and relationships need to be designed.
There is a tutorial here that could be useful to you.

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip


There is a free data model here that also may be helpful.
http://www.databaseanswers.org/data_models/customers_and_orders/index.htm

Full index of data models at
http://www.databaseanswers.org/data_models/index.htm

Good luck.