grouping 2 separate items together in report

[Guest]

I have a table describing files, and 2 other table showing which types of
pictures and which types of artifacts are in it. So Table 1 contains:
File ID; Name
1 ;Cardiff
2 ;Gloucester
3 ;Bristol
Table 2 contains
File ID; Pic Type
1 ; Buildings
1 ; Parks
2 ; Parks, etc
Table 3 contains
File ID; Art Type
1 ; Coin
1 ; Pottery
2 ; Coin, etc
How do I get my report to group like this:
File ID: 1 Name: Cardiff
Pictures: Buildings
Parks
Artifacts: Coin
Pottery
File ID: 2 Name: Gloucester
Pictures: Parks
Artifacts: Coin etc.

Many thanks! (back on 9th August)

 

[Al Camp]

I think your tables should be set up this way. (Just one table) Use the
new "Category" field to combine Pic/Art..etc into one field. It's the more
straightforward.
No need to break each Category into seperate tables... they represent the
same logical concept.

TownName Category Type
Cardiff Pic Building
Bristol Pic Park
Bristol Art Building

That should allow you to "break" the report by...

TownName
Bristol
Category
Pic
Type
Building
Park
Art
Building
Parks Etc
.... and so on

*OR* Two tables if really needed... connected by ID
Table 1
TownName
and...
Table2
Category
Type

hth
Al Camp

 

[Duane Hookom]

subreports for Tables 2 & 3. Main report based on Table 1.

 

[Duane Hookom]

I agree with Al. Based on the information provided, a single table for
Pic/Art might be all that is necessary.

Also, notice Al corrected the field name "Name" to a more appropriate
"TownName" since Name is a property of every object in Access and makes name
a bad choice of a name.

 

[Guest]

Thank you, Al and Duane, for your help.

subreports for Tables 2 & 3. Main report based on Table 1.