Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    12

    How to represent One to many relationship on the report....

    I have one to many relationship tables.At the table level the relationship is clearly represented by the main table (on the 'one'side') and the subdatasheet for the 'many' side(second table).These tables are being front-ended by a mainform(on the 'one' side) and a subform(on the 'many' side).My reports are based on underlying queries.My concern here is on how to represent this data relationships on the reports???? with subtotals and grand totals.????I have tried to put a subreport at a details section of
    the main report but there was some data duplicates....the same applies when I ran the query itself....is there any suggestions???Below is the sample illustration:
    Here Main Table One(on the one side)relates to Table Many(on the many side)

    Table One Table Many


    Record A A1,A2,A3,A4
    Record B B1,B2,B3,B4

    The Detail report should display
    Record A
    ` A1
    A2
    A3
    A4
    subtotalsA

    Record B
    B1
    B2
    B3
    B4
    subtotalsB

    Grand totals:Record A + Record B + subtotalsA + subtotalsB

    Could this be represented in summary form also????
    IS there any way to improve the above representation????
    Any suggetion is highly welcome and appreciated!!
    Thanks

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    The layout you describe is a pretty standard one for one-to-many relationships.

    If you want to suppress the details, there are a couple of ways to do that:

    1) Create a query that aggregates on the 'one' entries, and make a new report based on that query

    2) Use code to selectively hide or show the detail records (I would use an event sub for the OnFormat event of the detail section

Please reply to this thread with any new information or opinions.

Similar Threads

  1. design using relationship...
    By dsnyder in forum Database Design
    Replies: 2
    Last Post: 10-21-2008, 12:00 PM
  2. Many-to-Many Relationship
    By Carolyn1 in forum Database Design
    Replies: 0
    Last Post: 09-25-2006, 02:04 PM
  3. Many to Many relationship
    By Marlie in forum Database Design
    Replies: 6
    Last Post: 08-18-2006, 01:49 PM
  4. one to many relationship
    By pe_z in forum Database Design
    Replies: 2
    Last Post: 02-17-2006, 10:44 PM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums