jess Posted July 14, 2006 Posted July 14, 2006 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....
mlemmnapa Posted July 14, 2006 Posted July 14, 2006 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
Recommended Posts
This topic is 6769 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now