Forum Discussion
Laura_Thacker
6 years agoQrew Commander
Perhaps instead of having 2 forms in the child-table; you have 1 form and use Form Rules to control which data-set's are displayed based on which relationship (parent) is populated; this way you do not have to control every report to show one form v. another form in the same table because of the 2 different parents.
This is a very common function of a child-table to have more than 1 parent; but only data from 1 parent be visible at a time depending on the relationship.
Otherwise, you will run into issues with every report; and users who build their own reports may not be able to see the data they need because they do not have the ability to view the correct form you have designed from their report.
Typically, you will put parent 1 lookup fields in 1 section heading group; and then put the 2nd parent lookup fields in a second section heading group.
Then use 2 form rules - when [Related Reference Field 1] is not empty, show Section 1. When [Related Reference Field 2] is not empty, show Section 2. If users are adding to this table from the table (and not from either parent); then you will need to show the 2 related reference fields together on the form for the user to select one or other parent first.
This is a very common function of a child-table to have more than 1 parent; but only data from 1 parent be visible at a time depending on the relationship.
Otherwise, you will run into issues with every report; and users who build their own reports may not be able to see the data they need because they do not have the ability to view the correct form you have designed from their report.
Typically, you will put parent 1 lookup fields in 1 section heading group; and then put the 2nd parent lookup fields in a second section heading group.
Then use 2 form rules - when [Related Reference Field 1] is not empty, show Section 1. When [Related Reference Field 2] is not empty, show Section 2. If users are adding to this table from the table (and not from either parent); then you will need to show the 2 related reference fields together on the form for the user to select one or other parent first.
Wallace__DHS_Ye
6 years agoQrew Trainee
Is it possible to add multiple embedded reports within a form?
------------------------------
Wallace (DHS) Yeboah
------------------------------
------------------------------
Wallace (DHS) Yeboah
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
Yes, you can have as many embedded reports on a form as you like. But is that really your question?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- Wallace__DHS_Ye6 years agoQrew TraineeHi Mark
Yes, to provide more detail.
I have an embedded report within a form that was automatically generated when I created a table to table relationship. (report link from parent table is visible on child table). I would like to add an additional report link to showcase other data points from the parent table on the same form in the child table. Not sure how I go about doing that.
------------------------------
Wallace (DHS) Yeboah
------------------------------- MarkShnier__You6 years ago
Qrew Legend
As Laura stated, you can add the Report Link field and hence an Embedded report onto the form multiple times and specify a different Report for that embedded report to use. You set the report to use in the Form Properties.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------