create a flat file

M

Maggie

I have a table with a primary key HRID and a second table
with that is linked in a one to many relationship with the
first table by HRID. The second table contains education
information and can have anywhere from 0 to 5 records for
each HRID. I need to create a query that will show the
records by HRID and have the other Field Education in the
columns next to it. The records could have anywhere from
0 to 5 columns.

Any idea how to do this?

Thanks,

Maggie
 
Top