Hi,

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?

Lisa

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.

Thank you! I obviously had not thought of that.

You're welcome. I am glad I could help.

how do you create a "subreport" of the main report?

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

table 2:
ID, Claim, Description:
1 , 123, Pencil
2 , 123, Pen
3 , 555, Car

Then, I want the report looks like
Claim: 123
Name:

A
B
C
D

Description:

Pencil
Pen

Claim: 555
Name:

...
....


Could u help me please?

Thank you