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.
and from the "Shapes" table, it looks like this ...
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.
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