We have an "oncall" table that has auto-inc id, empid, from_date, to_date
Example: 12, 103, 2021-06-14, 2021-06,21
We use this to connect to our "employee" table (on empid) to show the name of who is oncall each week.
We'd prefer to NOT copy the employee name into this table but it seems we cannot use editing on the oncall table because of the employee join. Is this not possible? We don't want to do anything to the employee table, just edit the id number in to oncall table.
Table is on our intranet so I cannot share, but here is a visual:
If I understand correctly, you have a column connected to another table via foreign key, and you would like to change the ID in the original table that pulls the value form the connected table?
To be able to do this you would need to brake the foreign key relation, and choose the option Read from table on page load, and then make your modifications, then configure the foreign key relation once again.
Just make sure the editing for this column is enabled in the editing tab in the column's settings so you can make the modifications you need
If I misunderstood please explain in more detail so I can get a better understanding and provide you with the best solution.
We have an "oncall" table that has auto-inc id, empid, from_date, to_date
Example: 12, 103, 2021-06-14, 2021-06,21
We use this to connect to our "employee" table (on empid) to show the name of who is oncall each week.
We'd prefer to NOT copy the employee name into this table but it seems we cannot use editing on the oncall table because of the employee join. Is this not possible? We don't want to do anything to the employee table, just edit the id number in to oncall table.
Table is on our intranet so I cannot share, but here is a visual:
Thanks!
Hi Frank
Thank you for reaching out to us.
If I understand correctly, you have a column connected to another table via foreign key, and you would like to change the ID in the original table that pulls the value form the connected table?
To be able to do this you would need to brake the foreign key relation, and choose the option Read from table on page load, and then make your modifications, then configure the foreign key relation once again.
Just make sure the editing for this column is enabled in the editing tab in the column's settings so you can make the modifications you need
If I misunderstood please explain in more detail so I can get a better understanding and provide you with the best solution.
I am not 100 positive (because I'll need to try this) but I believe you understood me perfectly! Thank you for the advice.
You are most welcome
Do let me know if you need any further assistance, I would be happy to help.
Have a wonderful day!