Hi. I have a (Dresser Detail Master) table which IsPartOf a (Routings Master) table through [Record ID]. I want to restrict the user to one associated record only if possible so if the user submits a record on the (Dresser Detail Master) form and returns to the (Routings Master) form the ‘New’ option is not available. I have tried the following expression on the ‘Add’ action for the (Dresser Detail Master) table but the ‘New’ button is consistently invisible so that I can’t add even an initial record.
[Record ID]=[Record ID].[Routing ID]))<1
Is this the right approach and if so is my expression close to what is needed?
Any advice would be great, thank you.