Exporting 2 table in "flat file" lookalike

[LittleSmudge]

I just know this has been discussed before - but I'm having no joy with searching for solutions - so here is the problem.

tblItem contains records of items which can be parts of Collections >> tblCol.
Relationship is many to many so I have

tblItemCol
ItemRef FK to tblItem.ItemId
ColRef FK to tblCol.ColnId

What I need is a query that I can use in a TransferSpreadsheet that will output :-

tblCol.Field1, tblCol.Field2, tblItem.ItemId1, tblItem.ItemId2, .. .. tblItem.ItemIdX .. for as many Item records as there are in the collection

Yes this will create rows of different lengths.

Can it be done ?




G LS

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886