On Wed, 2009-07-15 at 11:11 -0400, Drew Jensen wrote: > Keith Clark wrote: > > I have a form which has two subforms connected by the same field in the > > main form. > > > > Does it matter in which order I fill in the information in the forms? > > > > Hi Keith, > > Well, there is one case in which order matters. If you insert a new > record into the master form then you must save this record before you > can enter data into the related sub-forms, just common sense really. > > Something to keep in mind: > Base will auto commit your changes when you leave a control attached to > one form and enter a control attached to another form on the screen. > > So - you have a data input form with a Master and two Sub forms. > Enter data into the controls on the Master form and then tab into the > first control on the first sub form. At this point the record in the > master form is saved to the table. > > Tab into the first control on the second sub form and the record > attached to the first sub form is saved to the table. > > > Can I jump form, to subform, back to form, to subform and so on, and > > then when I hit New Record on the navigation bar, will Base save all the > > information in all the forms to their appropriate tables? > > > > yes that is the idea - keeping mind what I said above however, there may > be no need to write some of the records again. > > > Do I need to hit the save record button when finishing each > > form/subform? > > > > Sometimes. If you entered data into only the master form or only a > sub_form and have not tabbed out of the controls then yes you need to > explicitly save the data. > > > I ask this because it seems that at times, we are losing the information > > on the subforms when we fill them all in, then hit the New Record > > button. Not all the time though. > > > > hmm- it shouldn't. The New Record is attached to ONLY the main form? > > Drew
Hey Drew, Well, I've told my user the pattern in which they should enter data and all seems well now. Not sure how they were going wrong though. I've made sure that the tab order also goes in the correct order. I'll have to wait to see if their are more problems. Thanks for the feedback. I was pretty sure I had it right! Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
