Hi all,
I have a very simple product database that I am designing, and am at the planning stage. This is probably a very basic question but I have never built a database from scratch before.
In one Table ("Main Table"), I have the fields: "Item Number", "Description", "Shipment Terms" and "Shipment Costs".
All the fields have manual inputs except for "Shipment Terms" and "Shipment Costs". "Shipment Terms" is restricted to a list of 10 set terms.
I want another Table ("Shipment Table") to have the list of those 10 terms, plus the "Shipment Costs" associated with them.
In the "Main Table", I now want the "Shipment Costs" to automatically pull back the relevant "Shipment Costs" from the "Shipment Table".
Is that possible or am I misunderstanding the concept of database structures?
Many Thanks,
Nick
I have a very simple product database that I am designing, and am at the planning stage. This is probably a very basic question but I have never built a database from scratch before.
In one Table ("Main Table"), I have the fields: "Item Number", "Description", "Shipment Terms" and "Shipment Costs".
All the fields have manual inputs except for "Shipment Terms" and "Shipment Costs". "Shipment Terms" is restricted to a list of 10 set terms.
I want another Table ("Shipment Table") to have the list of those 10 terms, plus the "Shipment Costs" associated with them.
In the "Main Table", I now want the "Shipment Costs" to automatically pull back the relevant "Shipment Costs" from the "Shipment Table".
Is that possible or am I misunderstanding the concept of database structures?
Many Thanks,
Nick