This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I managed to solve this by adding a formula field in the linked table which pulls out the record id using the function RECORD_ID().
So for your example:
add another field in the Customer table called “record_id” which is of the type Formula, in the f...