10 Replies Latest reply on Jun 6, 2017 8:58 AM by mikerevans

    Field cannot be modified until ---

    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