Solved: Showing a Ref Column's Detailed View for each item... - Page 2

Stelios_Papamic · 06-08-2020 06:27 AM

Hi!

I have a table named WORK which has two Ref Columns named OP_UID & PO_UID respectively. Each one is a reference to a row from a different table. Now in my WORK table’s view in the UX tab, it shows each item in the work table as expected by showing some of the column values in the primary and secondary header and clicking on an item reveals the rest of the columns. You can also click on an action that takes you to the referenced row’s details view of the respective table.

My client has asked me to directly show the referenced rows (all their info) of those two different tables (pointed to by OP_UID & PO_UID) in the WORK View. Is that somehow possible?

GreenFlux

Remove the related records (inline view) from your detail view. They should be their own table view, added separately to the list of views for the dashboard.

The Dashboard list should look something like:

WORK_TableView
WORK_DetailView
OP_UID_TableView
PO_UID_TableView
– and detail views for PO/OP if you want them.

Make sure you turn on Interactive Mode for the dashboard.

Selecting a record in WORK_TableView should update WORK_DetailView and filter the two child tables.

View solution in original post

Showing a Ref Column's Detailed View for each item in the master table