I am more familiar with join tables, SQL etc. I have 3 tables: “person”, “activity” and “activitylog”
“activity log” is essentially a join table that stores the person ID and activity ID.
I created two linked fields in the “activity log” table and AT created two fields for each:
“ActivityID”, “ActivityID (From activity table)”, “personID”, and “PersonID (from person table”)
I am updating the join table from Integromat and it works fine, but I don’t understand why AT creates two fields for a linked record?
What I’m trying to accomplish:
- log all activities people do and issue rewards based on accomplishing ‘missions’
- show me who has done what activities (and other aggregate reporting)
This is super simple in my old world of SQL server stuff, but is there a reason why AT creates 2 fields, or am I not going about this the right way?