Apr 25 2007, 12:18 PM
I am a beginning to intermediate level user.
I am trying to generate a standard report that pulls information from 2 tables. I want to be able to enter one code to pull in company name, address, and POC information from one table. Then I want to enter a (or several) SSN that pulls in last name, first name and other unique individual information - from another table. I want both sets of information to come together on one standard report.
I know this must be possible but it is way over my head. Can you please help me in "lay man's" terms?
Apr 25 2007, 12:55 PM
Use the data in one table to produce the "main" report. Use the data from the other table to produce a "subreport" of the "main" report.
Apr 25 2007, 01:52 PM
Thank you! I obviously had not thought of that.
Apr 25 2007, 03:41 PM
You're welcome. I am glad I could help.
Apr 3 2008, 03:26 AM
how do you create a "subreport" of the main report?
Apr 3 2008, 04:01 AM
What I meant is
Basically the Table 1 has a PK it self and tha same as table 2.
But there is 1 field in each table have a common value.
so say in table 1:
ID, Claim, Name:
1 , 123 , A
2 , 123 , B
3 , 123, C
4 , 123, D
5 , 555 , A
ID, Claim, Description:
1 , 123, Pencil
2 , 123, Pen
3 , 555, Car
Then, I want the report looks like
Could u help me please?