Inventory location tracking
Hello FM Users,
I really need your opinions or advices on my db.
currently, I've Products table which describe each products and stores quantity in US and China.
I need to track detailed locations of those quantity. So, I'm thinking of creating new table Location Tracking and create records for each Product quantity location.
would it be the great apporach to start? any better options?
I would appreciate your help.