Forum Discussion
MarkShnier__You
Qrew Champion
There will have been a field created on the left side of the relationship which is a "Report Link" field type. That is a special type of field which will "run a report" and put it on the parent record.
Set the FORM properties for that field to display the child record directly on the Parent record as an embedded table. Then make a report to control the columns and the sort of the children and adjust the form Properties to use that report. The system will have auto created a report called Embedded for Parent that you can use fore this purpose.
As for adding more than three lookup field, you can only add three lookup fields at a time, but you can do that as many times as you like. There is no limit.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Set the FORM properties for that field to display the child record directly on the Parent record as an embedded table. Then make a report to control the columns and the sort of the children and adjust the form Properties to use that report. The system will have auto created a report called Embedded for Parent that you can use fore this purpose.
As for adding more than three lookup field, you can only add three lookup fields at a time, but you can do that as many times as you like. There is no limit.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RebeccaMoore
4 years agoQrew Member
Does the information always display this way (as a grid), or is there a way to display each individual field as it looks on the child form?
------------------------------
Rebecca Moore
------------------------------
------------------------------
Rebecca Moore
------------------------------
- MarkShnier__You4 years agoQrew ChampionCan you post a screen shot of the whole form?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - RebeccaMoore4 years agoQrew Member
------------------------------
Rebecca Moore
------------------------------ - MarkShnier__You4 years agoQrew ChampionSorry, that is not what I was asking for.
You provided a a screen shot above which was just a wide but not deep screen shot of some field headers on a report, presumably on an embedded report on a form. I was asking to see the whole form on which that report was embedded so i could see the form and the report in the same screen shot.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - RebeccaMoore4 years agoQrew MemberHopefully this is right. Sorry. As you can tell, I'm a novice. I love the program, I'm just learning it VERY slowly!
------------------------------
Rebecca Moore
------------------------------ - MarkShnier__You4 years agoQrew ChampionIs your relationship that 1 Client has many Customers? So the Customer is the child table? If so, then yes, the customers will appear in a grid and if you need more detail you then drill into a customer in view mode and display the single customer record on its form.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - RebeccaMoore4 years agoQrew MemberSo, here's the thing. It really is a one on one relationship. Either can be the parent or child.
------------------------------
Rebecca Moore
------------------------------ - MarkShnier__You4 years agoQrew ChampionI think we should stand back and understand your relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------