Forum Discussion
DonLarson
6 years agoQrew Elite
Matt,
Is this your architecture? I made up additional table names as parents of the Document Selections.
If this ERD is wrong, then please correct me.
Without knowing more about your business case, I would change design so that the Documents table is related directly to the other Business Objects: Tasks, Opportunities ......
Now in each Parent Table you can modify the Add Document Button to take your Users to a specific form to add the Document for what ever your business rules require.
If the Document record needs to be related to an additional Parent in the future, you can have another QB Form that drives that process.
This should solve the issue in your question but there will be more things popping up for Document management.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Is this your architecture? I made up additional table names as parents of the Document Selections.
If this ERD is wrong, then please correct me.
Without knowing more about your business case, I would change design so that the Documents table is related directly to the other Business Objects: Tasks, Opportunities ......
Now in each Parent Table you can modify the Add Document Button to take your Users to a specific form to add the Document for what ever your business rules require.
If the Document record needs to be related to an additional Parent in the future, you can have another QB Form that drives that process.
This should solve the issue in your question but there will be more things popping up for Document management.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
MattMakris
6 years agoQrew Assistant Captain
Hi @Don Larson,
You nailed the data architecture (1st diagram). The reason we designed it this way is so you can 'attach' multiple documents to another record, such as an activity, while having the ability to 'attach' existing documents that records in other tables are linked to, so that we don't have to re-upload duplicate documents. For instance, if an Opportunity is linked to a proposal document and a contract document, I'd also like to link a task to those same documents. This way we aren't loading our database up with duplicate files and we're able to link multiple documents to single records..
------------------------------
Matt Makris
------------------------------
You nailed the data architecture (1st diagram). The reason we designed it this way is so you can 'attach' multiple documents to another record, such as an activity, while having the ability to 'attach' existing documents that records in other tables are linked to, so that we don't have to re-upload duplicate documents. For instance, if an Opportunity is linked to a proposal document and a contract document, I'd also like to link a task to those same documents. This way we aren't loading our database up with duplicate files and we're able to link multiple documents to single records..
------------------------------
Matt Makris
------------------------------