I am in the process of implementing a simple stock control/ordering system for a small food ingredients blending startup business.
The ingredients which we blend from our storage includes 15 items
We mix 6 default blends which are also sometimes customised
Where I have commenced is ...
1. "Ingredients Running Bulk" which includes the Opening Balance, Stock in, Stock out, Closing Stock and Order Alerts when stock reaches critical levels
2. A "Blend 1" File for each specific Blend 1 Order, blended for a customer. My thought was to have multiple tabs in that file for each order of Blend 1. Some blends will only be 2 or 3 times a year whilst others will be about 30.
That works just fine UNTIL I bring in Blends 2 - 5 files and have them accessing the same "Ingredients Running Bulk" file.
Was thinking some IFThen statements. Tried this line of thought but ended up in a deep hole going nowhere adding the additional blends
Then maybe why not all in one file. Then my head began to hurt.
Linked here is a simplified form of the two outcomes in one file. Linking between tabs is not functional!
Looking for some thinking / direction on how best to make this work.
Thanks
The ingredients which we blend from our storage includes 15 items
We mix 6 default blends which are also sometimes customised
Where I have commenced is ...
1. "Ingredients Running Bulk" which includes the Opening Balance, Stock in, Stock out, Closing Stock and Order Alerts when stock reaches critical levels
2. A "Blend 1" File for each specific Blend 1 Order, blended for a customer. My thought was to have multiple tabs in that file for each order of Blend 1. Some blends will only be 2 or 3 times a year whilst others will be about 30.
That works just fine UNTIL I bring in Blends 2 - 5 files and have them accessing the same "Ingredients Running Bulk" file.
Was thinking some IFThen statements. Tried this line of thought but ended up in a deep hole going nowhere adding the additional blends
Then maybe why not all in one file. Then my head began to hurt.
Linked here is a simplified form of the two outcomes in one file. Linking between tabs is not functional!
Looking for some thinking / direction on how best to make this work.
Thanks