penfold1992
Registered User.
- Local time
- Today, 11:02
- Joined
- Nov 22, 2012
- Messages
- 169
Hello all again,
So... I think I know the answer but I am not sure how to execute it.
I have two tables
1. Package Information
2. Package Uses
Table 1 contains information about packages, from what the package contains, contacts, priority etc etc.
Table 2 contains information about when the package is referenced,
Package Name (linked with Package Name in table1), Date of use and location.
I want to create a dynamic report about each package so I have a page "header like" section which contains information from table 1. THEN I would like a table under this which contains the columns in table 2 WHERE Package Name from table 2 = Package name from table 1
I dont think I can just add these columns in and turn them to "Tablature" design (for some reason it puts this inside the header section and I cant drag it down to the location I want on the page) so I think I have to use a "Sub Report"
this is where coding is required because not only do i need:
Main report - WHERE Package Name = Package Name selected in a form (I already have this set up and working)
Sub report - WHERE Package Name = Package Name (the way I set up the above one was to open it with a parameter... I am not sure if this can be done to the sub report to correspond with the Package Name listed in the header information with no issues...)
Is a sub report the right way to go?
So... I think I know the answer but I am not sure how to execute it.
I have two tables
1. Package Information
2. Package Uses
Table 1 contains information about packages, from what the package contains, contacts, priority etc etc.
Table 2 contains information about when the package is referenced,
Package Name (linked with Package Name in table1), Date of use and location.
I want to create a dynamic report about each package so I have a page "header like" section which contains information from table 1. THEN I would like a table under this which contains the columns in table 2 WHERE Package Name from table 2 = Package name from table 1
I dont think I can just add these columns in and turn them to "Tablature" design (for some reason it puts this inside the header section and I cant drag it down to the location I want on the page) so I think I have to use a "Sub Report"
this is where coding is required because not only do i need:
Main report - WHERE Package Name = Package Name selected in a form (I already have this set up and working)
Sub report - WHERE Package Name = Package Name (the way I set up the above one was to open it with a parameter... I am not sure if this can be done to the sub report to correspond with the Package Name listed in the header information with no issues...)
Is a sub report the right way to go?