Hi there,
As you can see, 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 an entry there, 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, 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 an entry there, 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
