In a database like this:
Main table
ID NAME
1 JOHN
2 PAUL
3 RINGO
Secondary 1 table
LINKID INSTRUMENT
2 GUITAR
2 BASS
3 BATTERY
Secondary 2 table
LINKID SON NAME
2 STELLA
2 JAMES
3 ZAK
i want to have a report of this type:
NAME INSTRUMENTS SON NAME
PAUL GUITAR STELLA
........BASS JAMES
RINGO BATTERY ZAK
But if i join tables in a query to create report i obtain this:
NAME INSTRUMENTS SON NAME
PAUL GUITAR JAMES
.........GUITAR STELLA
.........BASS JAMES
.........BASS STELLA
RINGO BATTERY ZAK
THIS IS JUST AN EXAMPLE, BUT I HAVE 8 SECONDARY TABLES
How can i do?
Sorry, but i'm not so good in english as well as in access.
Thanx in advance
Federica