My purchase order has 3 lines with seperate dataconnections to input the orders. Bascially I want to be able to input all of the information on my purchase order, save the form as the Purchase order Number assigned to it, so that later when I have payment information for that PO# I can open up that form and update it with date paid, invoice # etc... and finally submit the data to my database. My problem is It will only display one record at a time, I want to be able to see all of the records associated with that PO# and update them all at once. Also Since I have addNew in my initialize event, Whenever I do a save as (PO#) and open it back up the form is empty. So my thought was that If I put all my connections on Delay Open and save the Form until I am completely done with it (invoice #, Etc.) Somehow open my connections and submit to database. Right now if I do this it wont' submit anything and just displays the last record in all of my lines. Maybe I am putting Open in the wrong event?
I have tried a Clear Form button and it clears from my database also.
The only thing that I can think of is to fill out the form and use Export/Import until all of the info is completed on the PO and then submit. This form will be used by 3-4 other people and I was just trying to make it as simple as possible for them.