Hi Team,
I'm scratching my head at this one. I have 4 tables:
1. Sites
2. Daily Inventory Update (linked CSV file from SFTP site)
3. Manual Inventory Updates
4. Appointments
Typically for my inventory apps, i make a warehouse table but in this use case, the sites that need the stuff are also the warehouse that store the stuff in several cases. Does it make sense to create 2 relationships between the MIU table and the Sites table to indicate to and from regarding listed inventory items?
------------------------------
GMacri
------------------------------
Question
Design Question on Inventory System
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.