I have a simple task but seems to have some trouble to make it work. I have 4 tables
1.1 Employees table : I want to see and change which phone number (table 2) and which device (table 3) each employee has.
2.1 Phone Number table : I want to see and edit which employee and devices is linked to the phone number and also be able to change it in this table as well. So if I change the employee from a phone number in this table, the phone number in the employee table would change as well.
3.1 Inventory table : I want to be able to see and edit what number and which employee or worksite this number is assigned to.
4.1 Worksite table : I want to see and edit which device and phone number are assigned to each worksite
The problem I have right now is that if I use Inventory table and use a linked field for the 3 other tables, it works great. Table 3 Inventory is linked to all the other tables
Example : iPhone 8 is linked to John, Phone number: 111-222-3333 and worksite Newyork Condo
When I go in the worksite table, I see that it is linked to iPhone 8 but it does not link to the phone number or the employee. The solution is to show a lookup field. The issue is that the lookup field can’t be edited directly from the worksite table (I need to click on it to go to the primary field and then change it there)
How can I make the 4 tables directly linked without the lookup field?