Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2016
    Posts
    5

    Using my new 'Relationship" data to display correctly in my report - a beginners question.

    Hello everyone



    I have just learned about creating relationships and I have created one to link my two small tables. Table 1 is called "Shapes" and hold the information about a Dies which is a little like a cookie cutter. Table 2 is called "Pressure" and it hold the information about materials and the given pressure needed to cut the given "Shape". I have created a relationship as shown in the next screenshot.

    Click image for larger version. 

Name:	rel.png 
Views:	12 
Size:	8.0 KB 
ID:	26121

    and from the "Shapes" table, it looks like this ...

    Click image for larger version. 

Name:	sh.png 
Views:	12 
Size:	50.4 KB 
ID:	26122



    I have a report that prints out the information about each Die (Cookie cutter) which I will make into a binder. I wish to modify my report, now that I have now created the relationship, to show all of the settings from the "Pressure" table for each cookie cutter shape. So if it lists 3 different materials with their settings for each shape ... show them in a list. At the moment they are just being duplicated as I do not know how to get at the next record to be displayed from the pressure table to drag onto the form.


    Click image for larger version. 

Name:	rep.png 
Views:	12 
Size:	293.0 KB 
ID:	26123

    I am just duplicating the material info as I have just dragged the same static "Pressure" field.


    Also I have noticed that now each Record from the "Shape" table is being duplicated in the report until all of its linked Relationship "Pressure" records have been printed. Which sorta makes sense but its not what I want. Unfortunately after looking at videos an reading .... I don't know what I need to do.



    So to recap I need a report to print like this...




    Die Number 1 (from the Shapes table)
    ...Info related to die 1 .. (from the Shapes table)

    Die 1 Material info 1 (from the Pressure table)
    Die 1 Material info 2 (from the Pressure table)
    Die 1 Material info 3 (from the Pressure table)
    ... etc.. until no more records for Die 1 in the Pressure table


    ... next item in report ...



    Die Number 2 (from the Shapes table)
    ...Info related to die 1 .. (from the Shapes table)

    Die 2 Material info 1 (from the Pressure table)
    Die 2 Material info 2 (from the Pressure table)
    Die 2 Material info 3 (from the Pressure table)
    ... etc.. until no more records for Die 2 in the Pressure table




    Any help would be greatly appreciated.



    Paul

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Either have 1 report, RecordSource would be query of both tables linked like you have it, select all fields from both tables. Place all Shapes data in the Page Header and all Pressure fields lined up horizontally in the Detail section.

    Or have a Report based on table Shapes with data at top, then create 2nd subreport based on Pressure fields. Insert the Pressure report into the Shapes report and link them by Die Number.

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

Similar Threads

  1. Replies: 14
    Last Post: 08-23-2014, 12:35 PM
  2. Replies: 5
    Last Post: 04-01-2012, 12:50 PM
  3. Beginners question
    By nashr1928 in forum Access
    Replies: 4
    Last Post: 07-19-2010, 11:20 AM
  4. a beginners question
    By bluelondon in forum Access
    Replies: 0
    Last Post: 07-12-2007, 04:54 PM
  5. Access Relationship Display Question
    By dayrinni in forum Access
    Replies: 3
    Last Post: 02-05-2006, 11:16 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