referencing multiple keys

I have a table with 2 columns(membership number and name) as key. Child table has one of the column value (Name and date)and another column as key. When a record is added in the child table, the referenced key column(name) is updated with composite key(membership number : name) of the master table. How to fix this?

What is a key? - AppSheet Help

Make an “AppSheet-friendly” spreadsheet - AppSheet Help
Data: The Essentials - AppSheet Help

1 Like