Viewing Multiple Records in One Record
Hey everyone, I created a form with five different tabs and depending on the parent record, it will display one of the five tabs when someone fills out the form. Eventually, they will create five r...
Forum Discussion
The records are related by a table to table relationship.
------------------------------
Uchenna Ogbejesi
------------------------------
------------------------------
Uchenna Ogbejesi
------------------------------
OK. Take a look at this post and see if this is what you have in mind:
View/Edit Child records on Parent record form
------------------------------
Adam Keever
------------------------------
View/Edit Child records on Parent record form
------------------------------
Adam Keever
------------------------------
- It is not what I'm envisioning. I'm looking for a view of 5 tabs or the like to pull in data from the different records. Not sure if that makes sense or if it's feasible.
------------------------------
Uchenna Ogbejesi
------------------------------- MarkShnier__You
Qrew Legend
So are you asking if it is possible to view a form within a form. It's an unusual thing to want, but in theory it is possible to do. Does the Record you are on know the Record ID#s of the 5 records?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Yes, a form within a form I suppose. Is that complicated to do?
It does not know the record ID#s of the 5 records, just a related record ID# from a table to table relationship -- the ID of parent table record.
------------------------------
Uchenna Ogbejesi
------------------------------
- Uchenna,
What are your business objects and how are they related? Are the child records all different so your intention is organizing disparate things or are they the same object but with a different status? Or something entirely different?
Here is an ERD of the two scenarios
In the first case your Customer record has five tabs. In each tab is an embedded report from the five different tables.
In the second case your Customer record has five tabs but they are the five different values of Project Status. For this one you have to make five different Embedded Reports in the Projects table filtering on the current status of the Project. Once a Project goes from New to Assigned, it would automatically change tabs in the Customers form.
If your architecture does not look like either of these. Please draw it out and post.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------- @Adam Keever and @Don Larson here is what I mocked up, see attached. Let me know if you have any questions about this.
------------------------------
Uchenna Ogbejesi
------------------------------
