AnsweredAssumed Answered

Field cannot be modified until ---

Question asked by mikerevans on Jun 6, 2017
Latest reply on Jun 6, 2017 by mikerevans

Hi there,

 

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,

 

Mike

Outcomes