I have a table called Equipment List with fields
Item Id - Key
I have a table Calibration Checks with fields
Calibration Ref No - Key
An item can have several Calibration records.
I have a VC in Equipment List called Calibrations with formula
REF_ROWS(“Calibration Check”, “Item Id”)
This works fine and shows a list of Calibrations in the Equipment List Detail View.
I have a view showing Expired Calibrations
I want to link the Equipment List to this view so I can see the Equipment Description but because they have 2 different keys this won’t work.
Is this possible?