De-Normalize table (1 Viewer)

[jeremie_ingram]

I have data that I would like to use within another system. In order for this information to work as desired I will have to "de-normalize" my tables into a single record set.

Here is the issue, I have 40k+ records that have the majority of the data I need in a single table. I have directory path links to the photos related back to the primary key.

I need to merge these into a single line of information.

Examplethis is simply an example and not the true layout)

Tbl1
PKEY De1 De2 De3
123 North 15 Blue
124 North 28 Green

Tbl2
PKEY Path PhotoName
123 M:\Photo 123(a).jpg
123 M:\Photo 123(b).jpg
123 M:\Photo 123(c).jpg
124 M:\Photo 124(a).jpg
124 M:\Photo 124(b).jpg
124 M:\Photo 124(c).jpg
124 M:\Photo 124(d).jpg

The desired end result would look like

PKEY De1 De2 De3 Photo1 Photo2
123 North 15 Blue M:\Photo\123(a).jpg M:\123(b).jpg

...and so on until all photos for the record have been listed out.

Any suggestions? If a search topic similar to my issue could be recommended I would appreciate it greatly.

 

[jeremie_ingram]

HA

Got it finally to order up properly in a cross tab query. I now have it in the fashion that I need it.

Trouble was too many records processing at once and not the proper initial settings.