I’m working on an AirTable system that someone else started for me, and learning as I go.
I’ve got 3 Tables. A = Staff, B = Assets, C = Access.
On Table B I’ve got a Link Field to table A, so I can add a Staff Member’s name in a new record, and then add an asset against their name. I’ve also got a link field in Table A, linked to Table B, and it shows me a list of all the assets assigned to that member of staff. This was already made when I took over and works perfectly. As soon as I add a new asset and assign it to a member of staff, the asset is added to the list of assets in the Staff table.
I’m trying to create the same effect in in Table C. There’s already a link field where I select the staff member name, and then I assign them access rights to certain software. I’ve created another link field in Table A, expecting it to self populate with all the different software that the employee has access to. But it just sits there empty, waiting for me to manually select the software. And I’m allowed to select any software I want, even if that member of staff doesn’t have access. This duplicates work, and allows for errors.
I’ve checked all the settings of the new link field I’ve created. I’ve even gone as far as to duplicate the one I know is working, but the duplicated field then doesn’t work either.
I feel like I’m missing something really obvious somewhere. A tick box or something. Can anyone point me in the right direction?
Update: I’ve discovered that whenever I add the new Linked field in Table A, it creates a new hidden Linked field in Table C. When I delete this field, the linked field becomes a normal text field. So it seems the linked field might be linking to this new field instead of linking to the original Name field. I don’t know why that would be though.
