I’ve been trying to do this for a couple of hours and can’t figure out the best way to do this. Basically I have 2 tables, one of them has a list of people and their bio and the second one is a list of activities along with a name of a person who did that specific activity. Each person has multiple activities.
What I’d like to do is link both of the tables so the each person is linked to their bio but I can’t seem to change the first column of either of the tables (which is the name of the person) and turn that into a linked record. I tried making a duplicate column and turned that into a linked record but then that one does not update by itself.
I’m not sure if it is even the best approach to solving my problem, if anyone has any ideas then please let me know. I tried using the templates but they’re not doing exactly what I need to do.