Skip to main content
Question

Design Question on Inventory System

  • January 21, 2021
  • 0 replies
  • 17 views

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
------------------------------

  • Quickbase Alumni
  • January 22, 2021
If you're moving inventory from one Site to another, two relationships makes sense.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------