Forms and subforms

[Keith Clark-2]

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?
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?

Do I need to hit the save record button when finishing each
form/subform?

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.

Thanks,

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

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








---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

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: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[drewjensen]

Keith Clark wrote:

> 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!
>
>  

Great - I recalled something after I posted the earlier email. A blunder
I managed to make a while back:

A data input form with Master / Sub forms connected to 2 tables that
formed a One to Many relationship. It displayed only data from a single
record at a time. (the master and sub form where both detail forms in
other words)

I managed to setup the form in such a way that when in the sub_form
controls entering data in the last control of the sub_form cycled back
to the first control in the sub_form. (Of course sometimes that is
exactly what you want to happen)

Further (and here is the contributing factor to the problem) there was
no data navigator attached to the sub_form.

SO - what would happen is that the user could actually enter a second
record in the many table - without realizing it. Remember what I said
about the auto_commit - well it works for a single form also, so when
that wrap around happened on the sub_form data for the first (current)
record  was written and a input for a new record started.

Later if the form was opened it displayed the first record again - it
looked as if the data entry from the previous session was lost - it
wasn't - the form was simply not displaying it - no data navigator, so
nothing to tell the user there was multiple records in this table
related to the master form's record.

Just passing it along as a FYI.

Best wishes,

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Thu, 2009-07-16 at 21:34 -0400, Drew Jensen wrote:

> Keith Clark wrote:
> > 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!
> >
> >  
> Great - I recalled something after I posted the earlier email. A blunder
> I managed to make a while back:
>
> A data input form with Master / Sub forms connected to 2 tables that
> formed a One to Many relationship. It displayed only data from a single
> record at a time. (the master and sub form where both detail forms in
> other words)
>
> I managed to setup the form in such a way that when in the sub_form
> controls entering data in the last control of the sub_form cycled back
> to the first control in the sub_form. (Of course sometimes that is
> exactly what you want to happen)
>
> Further (and here is the contributing factor to the problem) there was
> no data navigator attached to the sub_form.
>
> SO - what would happen is that the user could actually enter a second
> record in the many table - without realizing it. Remember what I said
> about the auto_commit - well it works for a single form also, so when
> that wrap around happened on the sub_form data for the first (current)
> record  was written and a input for a new record started.
>
> Later if the form was opened it displayed the first record again - it
> looked as if the data entry from the previous session was lost - it
> wasn't - the form was simply not displaying it - no data navigator, so
> nothing to tell the user there was multiple records in this table
> related to the master form's record.
>
> Just passing it along as a FYI.
>
> Best wishes,
>
> Drew

Hey Drew,

That is exactly what is happening and it explains it all very clearly
now!  Thanks a bunch.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...