Hello Again,
Earlier I posted a copy of my Database for help in solving a Form issue,
the advice I got helped alot and I got the Form to Function with A Single Table,(Patient -Case 2) But someone told me to Normalize and Split the Tables in two,(Patient -Case 3) so I did but I'm having a very had time duplicating the Form operations as the previous one with the Single Table. I would like to go with the Patient -Case 3 in order to avoid issues down the road. I have included both versions of the Form in 1 zip file. Please Help and feel free to make changes to them to illustrate. I"m going nuts with this
I'm also still on a learning curve, so please bare with me?
Previous Post Message: "The Issue:
I have a Form (F_Payments), and my control field is the Case MRN:. What I'm trying to accomplish is this;
When I select a Case MRN from the drop down, I want to be able to enter my data into the fields to be saved in the table of the target Case MRN which is the AcctNum in the Table (T_Patient).
When I want to make a change or entry to the fields associated with the Case MRN: on the form, I should be able to simply select the Case MRN (AcctNum) and all the data should reappear and whatever changes I perform should save back to my table.
Problem:
1. What actually occurs is when I select the Case MRN, it doesnt always line up correctly and I have to select it again to get the correct Case MRN (AcctNum)"
Thanks for your patience in this.
Regards,
A...
Earlier I posted a copy of my Database for help in solving a Form issue,
the advice I got helped alot and I got the Form to Function with A Single Table,(Patient -Case 2) But someone told me to Normalize and Split the Tables in two,(Patient -Case 3) so I did but I'm having a very had time duplicating the Form operations as the previous one with the Single Table. I would like to go with the Patient -Case 3 in order to avoid issues down the road. I have included both versions of the Form in 1 zip file. Please Help and feel free to make changes to them to illustrate. I"m going nuts with this
I'm also still on a learning curve, so please bare with me?Previous Post Message: "The Issue:
I have a Form (F_Payments), and my control field is the Case MRN:. What I'm trying to accomplish is this;
When I select a Case MRN from the drop down, I want to be able to enter my data into the fields to be saved in the table of the target Case MRN which is the AcctNum in the Table (T_Patient).
When I want to make a change or entry to the fields associated with the Case MRN: on the form, I should be able to simply select the Case MRN (AcctNum) and all the data should reappear and whatever changes I perform should save back to my table.
Problem:
1. What actually occurs is when I select the Case MRN, it doesnt always line up correctly and I have to select it again to get the correct Case MRN (AcctNum)"
Thanks for your patience in this.
Regards,
A...
