Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
From your diagram, it looks like Vendor on the Vendor Table is just a free form typing field. That table should be renamed to what it is, which is Vendor State Assignments. The column for Vendor should come off the Planner table via a lookup as that table has the unique list of Vendors. The planner table should be renamed to be Vendors and before making the relationship to Vendor State Assignments, the key field should be changed to Vendor.
Then look any fields you nee from Vendirs (formerly planners) down to Vendor State Assignments, such as the Planner. Then from there lookup the planner lookup field down to Item. So a double hop to get there.
Then look any fields you nee from Vendirs (formerly planners) down to Vendor State Assignments, such as the Planner. Then from there lookup the planner lookup field down to Item. So a double hop to get there.