Return to FileMaker.com
I have my question about relation field
I have 2 tables is tbl_person and tbl_phone.
fk - email
My question is if i have update field pk email then fk email will update value same pk email?
Do you have solution for this case?
To answer your question yes if the relationship is setup correctly, but I highly recommend you rethink your primary/foreign keys.
Normally we recommend either using an auto generated serial number in the pk or use unique id's "Get(UUID)".
Retrieving data ...