I have a "membersprivatedata" table that is created from a members form and a "usergenerateddata" table each member creates by filling in a form I made. In the membersprivatedata table the system generates an ID called "contactid" and in the user generated data there is a system generated ID called "owner"...both of these are the same. How do I link these two tables on those fields? This should be a simple "key" connection so I can pull data from both data sets using that key identifier however I can't seem to figure out how to do it without writing code (I'm not a programmer). A reference field won't work since this is user generated data and I'm not going to go into the data base and manually create a connection one line at a time.
Thank for any help.