Pivot Table

  • Thread starter Thread starter Crispy
  • Start date Start date
C

Crispy

Anyone have any thoughts on how I could get the data below to show in a form
that lists JUST the artist name once, but all the albums they have recorded?

Thanks for any help




10CC Look Hear
10CC 10 CC's Greatest Hits 1972-1978
10CC Mirror Mirror
10CC Meanwhile
10CC The Original Soundtrack
10CC Sheet Music
10CC How Dare You
10CC Bloody Tourists
10CC Deceptive Bends
ABBA Gold
ABC Up!
ABC Alphabet City
ABC How To Be A...Zillionaire!
ABC The Lexicon Of Love
ABC Beauty Stab
Aces International Greensleeves
a-Ha Stay On These Roads
a-Ha The Blood That Moves The Body (Single)
Air Supply Lost In Love
Al Stewart Year Of The Cat
Al Stewart Past Present & Future
Al Stewart Love Chronicles
Al Stewart Famous Last Words
 
First you need to get your data organised into tables. One table for
Artists, primary key ArtistID, a second table for Albums, with a key to the
ArtistID in the Artist table.
Then it becomes easy.
You need a form and subform
Base the form on the Artist, and the subform on the Albums. Link the
child-master links to the ArtistID, and it will all happen.

Look up Relationships and Normalisation in Help.
--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanks - Fortunately my tables were organised just as you mentioned and it
works VERY well. Phew!

Another question though - When I see which albums the artist has recorded
(in the sub form), is there a way I can click on the album and go to the
form I have which has all the details of that specific album?

Thanks in advance

Regards
 
Preferably use a double-click, else whenever you click in the subform just
to edit data, you will be thrown into the other form. But the code is the
same, add a DoCommand.openform "frmAlbums" to either the click or
double-click procedure in the subform Current event.

Substitute your actual form name for "frmAlbums" above.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top