Forum Discussion
MarkShnier__You
Qrew Champion
It is possible that you were missing one of the most powerful and fundamental concepts of QuickBase. That is relationships.
https://help.quickbase.com/user-assistance/about_relationships.html?Highlight=Relationships
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
https://help.quickbase.com/user-assistance/about_relationships.html?Highlight=Relationships
Do you have any relationships in your application?.
For example your customer Table would hold all the customer information and then it would have child records for the other types of information. Then you would look up information from the parent record down to the trial tables.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
RebeccaMoore
4 years agoQrew Member
Again, Thank You! I believe that I can separate some of this information into a table to table relationship. I was able to create the relationship and it works perfectly, but now I have 2 questions.
1. Can I change the way the child information appears in the parent? If so, how? I need this information to appear in parent table as if it were a separate tab.
2. I have more than 3 fields that I would like to link. Is that possible, maybe with a formula?
------------------------------
Rebecca Moore
------------------------------
1. Can I change the way the child information appears in the parent? If so, how? I need this information to appear in parent table as if it were a separate tab.
2. I have more than 3 fields that I would like to link. Is that possible, maybe with a formula?
------------------------------
Rebecca Moore
------------------------------
- MarkShnier__You4 years agoQrew ChampionThere 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
------------------------------- RebeccaMoore4 years agoQrew MemberDoes 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
------------------------------- 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
------------------------------