Hierarchy View OR Tree View-MOD

[ABBA]

I have a list of Oil Wells…These Wells have Sections, Routes, Pumpers. Each Well has-Status Change, Well Test. Also each well has Facility the Oil, Water and Gas is Measured. I would like to present a Hierarchy View of
Wells–Section–Route-Pumper-Status Change–WellTest

[WillowMobileSys]

ABBA:

Hierarchy View of
Wells–Section–Route-Pumper-Status Change–WellTest

If all of these are columns on the same row you could use a Grouped View. Let us know if this is what you are looking for.

For example here is a table view of Work Orders that are grouped by Start Date -> Work Type -> Service Type -> rows

Start Date Group

Work Type Group for 3/30/2020 Start Date

Service Type Group for the Order Work Type

Data Rows in the Installation Service Type

[ABBA]

MasterWell Table…
Wells–Section–Route-Pumper-Status Change, these all are Column Headers in the Table.

Well Test is another table, with reference to Wells from MasterWell Table

[WillowMobileSys · Accepted solution]

You can still use a Grouped View like above using your Well Test Table.

You would pull in the other columns from MasterWell through the Ref column.

For example, in the Well Test table create a Virtual Column for Section and assign it like this:

[Well].[Section] — where [Well] is your Ref column to MasterWell

Repeat this for Route, Pumper and Status Change.

With all of these now virtually in you Well Test table, you can create the Grouped Table view like described above.

Does this help?

[ABBA]

Thanks–SOLVED