I have a doc which utilizes one “Master” table (list of people’s names and demographic info) and a separate table (“Device” table) which has a lookup column that references people’s names (the display column from the “Master” table). The “Device” table is a list of tablet ID’s which are assigned to certain people. When tablets break, are lost, etc., I might assign more than one tablet per person.
What I’m looking to do is create a column on the “master” table that references the tablet ID’s that are assigned to those people on the “device” table. I’m not sure if that makes sense. I can’t share the table because of confidentiality reasons, but if anyone needs one in order to understand what I’m trying to explain let me know and I’ll try and recreate it.