Once again, i have thought myself into a corner…I am wanting to revamp the procedure for adding a patient admission record in order to resolve the issue with the incorrect hospital information being sent to chat session, as show in this post
So my idea to get around this was to instead create an “admissions” form and a separate table to contain the admissions records. I added a action to create an “admission” button on the patient record if [In Hospital] was false, and used LINKTOFORM() to show the form and push some information from the patient record to the admissions form:
of course if this action is triggered from an actual patient record, the patient name is automatically filled in.
But this has created a little bit of a problem. How can I now take the Room number from this form and push it back to the Room column in the Patient table?
I definitely want to learn my way out of this one, but it seems at the moment, the path of least resistance may be just to eliminate the quick edit option and force the end user to edit the record “in one shot” to ensure that all elements of the record are changed at once, since quick edits are processed as individual changes.