martinrobson
Programmer
Hi,
I have a strange problem.
I have 2 forms. Form 1 contains an id field which i need to display on form 2, so i have to have form 1 open when i access form 2 so that it can reference the id.
The problem i have is that some of the data which is entered on form 2 requires the data from form 1 to be in the database table. Unfortunately because form 1 is still open it hasnt been submitted.
Is there anyway that i can set form 2 up so that when i click the save button, it closes form 1 (adding its data to the table) then closes form 2 (adding its data to the table)?
Thanks in advance for your help
I have a strange problem.
I have 2 forms. Form 1 contains an id field which i need to display on form 2, so i have to have form 1 open when i access form 2 so that it can reference the id.
The problem i have is that some of the data which is entered on form 2 requires the data from form 1 to be in the database table. Unfortunately because form 1 is still open it hasnt been submitted.
Is there anyway that i can set form 2 up so that when i click the save button, it closes form 1 (adding its data to the table) then closes form 2 (adding its data to the table)?
Thanks in advance for your help