Hi everyone,
I am trying to create a database for work, and something has got me completely stumped. I've watched youtube videos, googled it and I just can't get it to work. I want one field in the table to lookup that field, find it in another table, and return the associated value so I can create a calculated field in that table.
1. so I have a table called Purchase Orders. In this table I have Purchase Order No. and then lookups from other tables e.g. Product>Blueberry, Supplier>Supplier A, Country of Origin>Argentina
2. In Purchase orders, I have a field called "Subproduct" this is basically product format, I deal in say 10x125g Punnets, or 10kg bulk boxes.
3. In the Subproduct table, I imported an excel where I have the subproduct name, and then it's associated weight in kg.
4. I want it so that when I select subproduct in Purchase orders, it will lookup that subproduct in the Subproduct table, and return the Weight KG value, and put it in Weight Per Box in Purchase Orders.