Forms 6.0 - problem commiting form

[Quoted] [Quoted] 1) Database block with subject information
2) Database block with form information
3) Control block containing display items and buttons.

The first data block has a field called subj_seq as does the second data block. At first, I did not set up these two blocks as master-detail, but since the form wasn't working I tried to do this hoping that it would fix my problem. It didn't.

The purpose of the first data block is to have the user input values into these fields which will then give me the subj_seq which will get inserted into the second data block. So, although the first data block is based on a table, I do not want any data to get inserted into this table - it's only there to make sure that only valid data gets inserted into the second table.

I have a button in the control block that is used to save the data. Right now I have it doing a go_block('second block') and then commit; I've also tried a form_commit; but that doesn't seem to fix the problem either. The form is trying to commit the first data block and coming back with an error because that subject has already been entered in the database. How do I get my form to only insert the data that I've entered in the second data block?

Thanks for any help!
Vanessa Received on Fri Mar 21 2003 - 15:14:48 CET