I have a custom table that has the 'Save data per company' property set to 'Yes', and a standard table that has this value set to 'No'. I have added a reference field on the standard table using the recId field of my custom table. I created a RefRecId EDT with the reference table set to my custom table. My custom table also has an alternate key based on the natural key. This has automatically added the natural key to the 'AutoIdentification' field group as well.
When I look at the data in the standard table in the SQL database, I can see that the RefRecId reference field I added has been populated with RecId's from my custom table. So far so good.
When I look at the standard form where I have added my reference field/group, I am expecting to see the alternate key value populated. All I see is a blank value! The strange thing is, is that when I select the value, close the form and open it, I can see the alternate key value has saved, but there is nothing different when I look back at the SQL table.
The only different thing I can see here is that the data was imported using the data management framework and in a slightly older version of D365 FinOps. I recently upgraded to version 10.0.13 with platform update 37.
Has anyone else seen this issue before? If so, how did you manage to overcome it?
Thanks in advance.
Sarah
