Related fields from two tables
Sorry if this is a repost, but this has been tricking me for a little while now.
I have an orders database that created orders for customers and is specified by the orderID field. In the layout there is a portal going to a table that lists all the products for this order. These are related by orderID.
I have another field that describes whether or not the order will be shipped.
I pretty much want to create a field in the products table that reflects what the shipping method in the orders table is. So if it changes in orders, it will change in products.
Is this done through a calculation or a lookup?
Am I way off base?