Using FM Pro 8...

I'm trying store about 1000 precinct maps of our county in a DB. I want to query the DB so that I only export a limited number of maps at a time. For example, export all maps in House District 35.

So I've create some text fields that categorize each map by House District, Senate District, Cong. District, and finally Precinct. However, there are actually two types of maps per precinct (TypeA and TypeB)...and possibly 5 maps that cover one precinct.

Any way to ease up the import process? But more importantly, how would export a group of these?

Thanks....

Store all the maps in a child table to make them easier to find and work with.

For importing you could then just import all the maps at once into this table but it coudl be ricky to properly code them all with the proper foreign keys and types.

For exporting just find the related map records to your precinct or whatever and then create a lopping script to export them. You'll have to use variables to create dynamic field names and paths to supress all the export and save dialogs during the looping script.

It's all very doable but not what i woudl consider a novice task. good luck.

-Mark L