Hello all.
As you can see from the attachment, I have two forms and two tables. The first form (Initial Patient Report) works perfectly, with the data being updated depending on the number I choose. No problems there. In the second form (Initial Cancer Stage), I'd like to be able to search the "Initial Patient Report" table by number so that it fills in the DOB, Gender, Ethnicity, Doctor fields again. But as well, I want it to also search the "Initial Cancer Stage" table and if there is a pre-existing entry there with the same number, have it fill in the rest of the fields in the "Initial Cancer Stage" form. Does this make sense? Any suggestions?
Thank you so much!
Dino
As you can see from the attachment, I have two forms and two tables. The first form (Initial Patient Report) works perfectly, with the data being updated depending on the number I choose. No problems there. In the second form (Initial Cancer Stage), I'd like to be able to search the "Initial Patient Report" table by number so that it fills in the DOB, Gender, Ethnicity, Doctor fields again. But as well, I want it to also search the "Initial Cancer Stage" table and if there is a pre-existing entry there with the same number, have it fill in the rest of the fields in the "Initial Cancer Stage" form. Does this make sense? Any suggestions?
Thank you so much!
Dino
