im about to create a stock solution and before I try to reinvent the wheel, which I sometimes do if I don’t ask here first, do you have any tips / do and dont’s?
Heres My problem that I’m writing a solution for.
I put Beds into houses. All beds consist of two items, the base and the mattress. There are two types of beds and mattress, singles and doubles. I can reuse bases but not mattresses. I want to buy beds and mattresses and keep them in a stock location. All stock is in same location. I will be showing a bar chart with stock levels of items on a dashboard to prompt me when to reorder when levels are low. When I go to my stock location and take items I want to record what I’ve taken and where I’ve taken it to.
I want to to purchase items and put them in to stock.
i want to be able to show a bar chart of my stock levels
i want to be able to take items from stock and use them
i want stock levels to reduce on my chart
I want to record where i have taken my stock
ive read that I perhaps need 3 tables to achieve this and for it to work properly. Can anyone advise please?