Adding result box next to drop down menu

[jzwp11]

The notes/complications form should be a subform in the patient details form. See the patient details form in the attached.

[ashu.doc]

yes thats working now, what about F_general surgery, shall I add it as another subform to F_patient details?

[ashu.doc]

Thanks for your help its working nicely so far.

[jzwp11]

yes thats working now, what about F_general surgery, shall I add it as another subform to F_patient details?

As I mentioned, the relationship to this table does not look correct, so I would recommend fixing the relationships before worrying about forms.

[ashu.doc]

Hi again
I have created a F_Alldetails and a subform F_patientdetails in it and other two subforms F_opnotesandcomplication and F_surgicaldetails under the subform F_patientdetails for entering the details of operations. So far when I am filling the patient details form all the details are going under one patient ID (which was my earlier worry). I am sending you the file to have a look at it.

LOGBOOK.zip

what i am trying to do now is to add a button in F_patientdetails to add a new patient detail under the same sugeon, but when I am doing by button wizard it can either open a complete new F_alldetails or it is opening a new F_patientdetail form as a separate, which if I fill up, the data will not go under the same surgeon. Is it possible to put a button like that which opens a new F_patientdetail under the same F_alldetails?

thanks

[jzwp11]

So far when I am filling the patient details form all the details are going under one patient ID (which was my earlier worry). I am sending you the file to have a look at it.

You have to make sure that you are using the correct record navigation tools at the bottom of the respective forms. There will be one set for the patient details and another for the surgeon details. I would also recommend that you put a control for the patientID on the patient detail form. The op notes and surgical details do apply to the patient based on your relationships. If you look in those tables, you will see records for both patient 26 and 27, so the forms seem to be populating data for more than one patient.

what i am trying to do now is to add a button in F_patientdetails to add a new patient detail under the same sugeon, but when I am doing by button wizard it can either open a complete new F_alldetails or it is opening a new F_patientdetail form as a separate, which if I fill up, the data will not go under the same surgeon. Is it possible to put a button like that which opens a new F_patientdetail under the same F_alldetails?

I'm not sure where you tried to add this button, but I have added it in the patient detail form in the attached.

[ashu.doc]

Hi
Thanks, thats working perfect, how did you do that can you explain?

[ashu.doc]

Hi
I have found it how it works, thanks anyway.

[jzwp11]

You're welcome. Glad you figured it out. (I just used the command button wizard).