As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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!