KellyLyons1
3 years agoQrew Cadet
Automation to change edit a field in a parent table from child table
I would like to create an automation in a table that will allow me to modify a record in a parent table if needed.
Here is my scenrior:
I create or edit a record in Table B, before closing the record i would like a pop up to ask if ( or anything else that can ask me to change the record in the parent table) I would like to modify a specific field in the parent table ( the field is "reminder date" in table A)
Basically I create or modify a record in my "estimate" table, I would also like to be able to change my "reminder date" for the parent record (patient table)....
I will eventually use pipelines to do this, but I need to set up this up quickly.
Any thoughts?
------------------------------
Kelly Lyons
------------------------------
Here is my scenrior:
I create or edit a record in Table B, before closing the record i would like a pop up to ask if ( or anything else that can ask me to change the record in the parent table) I would like to modify a specific field in the parent table ( the field is "reminder date" in table A)
Basically I create or modify a record in my "estimate" table, I would also like to be able to change my "reminder date" for the parent record (patient table)....
I will eventually use pipelines to do this, but I need to set up this up quickly.
Any thoughts?
------------------------------
Kelly Lyons
------------------------------