multiple entries in a form/subform and how to move through navigator

[cwessel]

I have growers with multiple orchards and blocks in my database. When
a query is created, the grower name is repeated for each orchard under
that grower.

When I create a form, I have the grower name in the main form and the
orchards and blocks in a subform underneath the grower name. The
subform shows all the orchards a grower has at one time. When I enter
to go to the next grower and his orchards, I have to enter through the
number of orchards that the previous grower has even though the screen
is the same.

For example, if Grower X has 4 orchards, I have to enter 3 more times
after the current page to get to Grower Z and his orchards - the info.
stays the same each enter because all the orchards are on the page.

How do you get the form to just enter once and it goes to the next
grower and his orchards?

[MGFoster]

cwessel wrote:

I have growers with multiple orchards and blocks in my database. When
a query is created, the grower name is repeated for each orchard under
that grower.

When I create a form, I have the grower name in the main form and the
orchards and blocks in a subform underneath the grower name. The
subform shows all the orchards a grower has at one time. When I enter
to go to the next grower and his orchards, I have to enter through the
number of orchards that the previous grower has even though the screen
is the same.

For example, if Grower X has 4 orchards, I have to enter 3 more times
after the current page to get to Grower Z and his orchards - the info.
stays the same each enter because all the orchards are on the page.

How do you get the form to just enter once and it goes to the next
grower and his orchards?

Use the Link Master Fields and Link Child Fields on the subform control
to link by GrowerID. This assumes you have a GrowerID in the Growers
table and a GrowerID in the Orchards table.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)