I have another issue regarding "BSW_Ref" and "Metro_Ref"
"Metro_Ref" was the original unique identifier, but then the requirement changed as we needed the entry to be left blank if needed. I then introduced "BSW_Ref"
In the layout I have a portal to the second table "Metro_Instruction_Tasks" in which I enter an "Item Number" and it brings up the relevant data. Only when there is an entry in "Metro_Ref"
However I would like to be able to use the "BSW_Ref" in the relationship as it is automatically generated, and also unique. It seems that the link is still relying on "Metro_Ref"
Below is a diagram of the relevant relationships,
Thanks in advance,