Foreign Key Relationship
I have 9 forms that contain various bits of data. Each form has a RosterID field. How to I link all the forms together [foreign key] using the RosterID field?
I looked at the Dynamic field but I can't see where I would create a foreign key to link the forms. I see were it is a connection to display a specific field but that is not a relational link for two tables.
Here is a direct link to what I am trying to do, the red tabs are the forms/tables that need to be related via the RosterID field. https://aableh.net/ussvi/member-information/
I have been trying to get this to work for a week now without any success. Please help.