Multiple columns of one table reference to another lookup table with one column

Mayur_RJ
Participant I

Hello everyone, I was working on a scenario and wanted to check for options and workarounds for my situation.

Situation :
table A with columns to capture status changes recorded by 2 different audience.
table B contains one column with all standard status values.
table A status columns are ref to table B.
Created a dashboard with one table view with status and other detail view with matching status selection.
1st set of audience filtering is working fine
2nd set of audience filtering should be based on a second status column but it is filtering based on previous ref column.

is there a way to change the order of ref columns.

Thanks in advance!!

0 0 136
0 REPLIES 0
Top Labels in this Space