Look up inventory/stock management solutions because it sounds like that is what you are describing.
I would also read up on data modeling strategies. Wikipedia is a good place to start.
So I haul grain with TRUCK 55 from FARMER A and drop it in my shed in BAY 1 then I process it and load it on TRUCK 67 and take it to the FIELD 1 and plant it..
The bold items are all the nouns in your statement. They are all candidates for tables.
Yes and the verbs may also play a part in data structure:
haul (to and from), store (drop), process, plant
these "actions" may well be a table (or two) with date/time and joins to the nouns, as well.
1 of 1 people found this helpful
Here's my quick take on this:
TRUCK 55, BAY 1, and TRUCK 67 could all be locations.
FARMER A could be a suppler (or vendor - I use them synonymously), a customer, or both.
Movement from farmer to truck to storage to processing to truck to field are all transactions.
I've created a general data model that might help you organize this data. The data model is a free PDF and can be found at FileMaker Inventory Resources (look in the File section, IMS Data Model).
Thank you for sharing these resources, Daniel!
Sent from miPhone
Great link and material -- thank you, Daniel.