Grouping

  • Thread starter Thread starter Angel_G
  • Start date Start date
A

Angel_G

Is there a way to do grouping in a form as you do in a report?
I want a form to group records (sales) per customer name, without repeating
the customer name, phone etc for every sales transaction.
 
Yes, use a main form based on the Customer table (or on a
query based on it) to capture your "header" data, and an
embedded continuous subform for the detail.

Create the main form with the customer fields you want.
Then create a columnar continuous form based on your
detail table (or a query based on it). Once saved, open
your main form in Design mode, and drag the continuous
form from the Forms window onto your main form. If you
have Wizards enabled (it's a toggle button with a wand and
five stars), it will prompt you to enter the fields from
each form by which the data is linked, which is stored in
the Link Master Field and Link Child Field properties of
the subform. Now when you view a customer's main record,
only their detail records will show.

HTH
Kevin Sprinkel
 
Back
Top