Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
This sounds like a classic many to many relationship situation.
One manual has many supporting documents but also one supporting document supports many manuals.
The way this is done Quick Base is to create a middle table called supporting document manual assignments.
One manual has many supporting document Manual assignments.
One supporting document has many supporting document Manual assignments.
One the manual record you put the report link field to show the supporting document Manual assignments right on the form as an embedded report. .
On the supporting documents you put the the report link field to show the supporting document Manual assignments.
There is also a way to migrate your existing data over to the new middle table.
When you are done you will delete the relationship where 1manual has many supporting documents.
One manual has many supporting documents but also one supporting document supports many manuals.
The way this is done Quick Base is to create a middle table called supporting document manual assignments.
One manual has many supporting document Manual assignments.
One supporting document has many supporting document Manual assignments.
One the manual record you put the report link field to show the supporting document Manual assignments right on the form as an embedded report. .
On the supporting documents you put the the report link field to show the supporting document Manual assignments.
There is also a way to migrate your existing data over to the new middle table.
When you are done you will delete the relationship where 1manual has many supporting documents.