I have a table in my base that captures information about tasks and what person they are assigned to. The field with the person’s name is a linked filed to another table that captures information about them and their company like contact information. Since we have multiple people working for some of the companies, I would like to create a lookup field for my task sheet that shows which company they are associated with. However, since the table with that information is linked —> that way, it isn’t showing up as an option when I try to create a new lookup field. Any ideas on how to fix this?
I tried to write an automation, but because these records have different IDs, I can’t figure out how to get it to write back to the correct project. I also tried to do another linked field that read <---- from the contact information sheet to the task sheet, but it just started to create new records when I put the information in.