One main record, many sub records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys.

I am stuck on how to make one record appear with all its associated sub
records. What I am doing is almost identical to a scenario where you have a
customer in a video shop, and the report you want to generate is one that
shows some customer details, and along with that it shows all the videos that
that customer has borrowed without repeating the customer detials for each
video borrowed.

So I guess I kind of want an output that is similar to the input, namely a
form with a sub query/form where the customer details are entered in the main
form, with the numerous video details being entered in the sub query/form. I
actually have used a sub query, not a sub form if that helps.

Thanks in advance,

DB.
 
Presumably you have a query that contains the records from the various
tables, and in the query the customer details do repeat on every row.

1. Create a report using this query as the source.

2. In report design view, open the Sorting And Grouping box (View menu).

3. Select the CustomerID field on the first row of the dialog, and in the
lower pane set Group Header to Yes. Access adds a "CustomerID Header"
section to the report.

4. Put the header fields into this new section, e.g. name and address. (Drag
them from the Field List--also on the View menu if you can't see a Field
List.)

5. Put the fields that you do want repeated into the Detail section.

If you need an example to follow, open the Northwind sample database, and
look at the Invoice report.
 
Back
Top