Hi All
I got around this by adding a field Object_PK_Gen and then setting a short text Object_PK field to Unique and Required.
The text formula uses the auto increment field and looks like this:
The short text has a conditional rule on it like this:
You can then do the same in other objects connected to the previous object using Object_FK_Gen & Object_FK like this:
&
I know this isn’t exactly what you are asking for but it is a work around that doesn’t use code and it will run on all previously added records.
You can then use Primary Key to search all connected objects with the same Foreign Key.
Craig