We have the current object structure set up:
Sales Reps(user)
Jobs
Rooms
Door Types
Currently Sales reps are connected to a Job (1>Many)
Jobs are connected to a Room (1>Many)
and Rooms are connected to Door Types (1>Many)
So for example we will have a Job with an assigned sales person that will have many rooms, each room will have one door type.
I would like to create a table on the "Job" Details page that shows the Connected door types and lists the rooms that each door type is present in. Ex. the Madison (door type) and then a rooms column that lists: kitchen, bathroom 1, etc.
I have no issue creating these lists when the connection is just one deep. However, when I attempt to do this in this situation, I have no access to the Door Types data source on the Job details page when I create a table.
Does anyone have any insight on this?
Thanks in advance,
Eddie San Juan