Export Related Data

[ShawnR]

I have a need to export the related data of a database. I want to create a "flat" file if you will.

I have a Database with Vehicle Information, a connector database, and a parts database.

I want to export the Vehicle information, with all the associated parts.

What I get is a .tab file with the Vehicle info on the first line with the information for the first part, then all the other parts for the same vehicle have no vehicle info, only the part info.

How do I get the vehicle info to export with all the part info.

Here is a sample of what I get in the exported file:

2178 ATV Arctic Cat DVX 400 70-812 $352.00

70-822 $394.00

70-592 $352.00

70-582 $352.00

CC-S08 $310.00

70-692 $394.00

VC-S40 $135.00

CG-S04 $180.00

IV-S03 $34.00

EV-S03 $34.00

IV-S04 $34.00

EV-S04 $34.00

VG-S01 $15.00

282 ATV Bombardier DS 650 Rotax VC-B03 $380.00

VC-B04 $140.00

IV-B00 $50.00

EV-B00 $50.00

etc...

Thanks for any help.

Shawn

[comment]

Try exporting from the join table.

[ShawnR]

Thank you! That did it... Just have to re-work some scripts..

Thanks again!

Shawn