Hi guys,
I’m sure is a simple fix but at the moment my brain stopped working. I know how to do a relation between a parent and a child. I need the child database to relate based on 2 parent databases.
i have 3 databases:
So in the tab Cranes i need to see the cranes from that specific Project, it shows me all the cranes from all the projects.
Can you clarify which columns need to be related to what in each of the three tables you are showing? I’m guessing you need a Query column, but I’m not clear on what you are looking for.
I think your use of the word tab is throwing me off, so forgive me if I’m misunderstanding anything. Tabs are the the different tab screens on the front end of the app. What you are showing are tables. Tables contain row and columns. Plus, I can’t see all of your table names, so I’m trying to determine what is what.
Anyway, I assume this latest screenshot is coming from the table you are showing in your first screenshot? Based on your first three screenshots, are you trying to connect the first table to the second table by linking both project and pages?
Sorry that I’m not able to explain properly and thank you for your help.
I need to have a list of Projects, each of them to have a list of pages and each of them pages to have a list of elements specific for that project. Forget about them tables. I’ve made an app for the project I’m working in. I need to make the app available for multipel projects so I’m working on app’s structure.
something like this
OK. I think I’m following the hierarchy now.
So what I would do is create a Relation column in the Project table linking the project name to the project name in the Pages table. Not sure if you need it, but you could also create a Relation column linking the project name to the project name in the Cranes table.
In the Pages table, create a Query column that links the project name and page name to the project name and page name in the Cranes table.
That way, when you build your screens, you can first show alist of projects. When you go to the details screen for a project, add a collection sourced from the relation column in the Projects table. When you click on a specific page to view it’s details in that collection, add another collection sourced from the query column in the Pages table. That should ultimately show just the Cranes for the selected Project and Page.
Thank you for your help, so far so good. How can I do that in a query column?
thank you, you are a star 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
