Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
7 years ago

Need to have 2 fields that pull from the same related table on 1 form

OK so I have an interesting question here. We build and install custom closets. We'd like to track our installations so we can see how many trips we make to a job, and which installer(s) were on the j...
Forms
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Right, that is what I thought.
So then you will need a many to many relationship setup.

One Install has many Installation Assignments.
1 Installer has Many  Installation Assignments.

and then you will end up deleting your table for the 1 Installer has many Installs.

If you have existing live data in your app, then there are ways to migrate that data across to the new relationship setup before deleting the relationship and losing the data.