SteveB Posted July 25, 2002 Share Posted July 25, 2002 I have a parent file and 2 child files. The user selects a found set in the parent file to export. How do I export the related child records into their own files? Will FM make the records in the child files the found set automatically when it creates the found set in the parent file? Link to comment Share on other sites More sharing options...
Vaughan Posted July 25, 2002 Share Posted July 25, 2002 There could be two ways of doing this, depending on whether you want the *records* exported or just the *data*. To export the records will be hardest, it may mean exporting the master records then using a looping script to go to the first exported master record, go to its related records and export them, then return to the master database and go to the second exported master record, go to its related records, export them... etc. A lot of work and a lot of export files to try to make sense of. If you only want the related data, I'd suggest creating a calc field in the master database that uses the Design function to concatenate all the related record values. Depending on the export file delimiter, you may have to massage the calc field to create a menaingful string out of the related values. I've done something like this before and it works well. Link to comment Share on other sites More sharing options...
SteveB Posted July 25, 2002 Author Share Posted July 25, 2002 I need the records, not the data. Besides, I'm doing a kiosk, and I've found that design functions that reference file names don't work after being run thru Developer Tool...the file references don't get changed. Link to comment Share on other sites More sharing options...
Vaughan Posted July 25, 2002 Share Posted July 25, 2002 Then it's gonna be ugly then... Unless you do it the other way... bring the related master information inot the related records (through calc fields) then just find and export the related records you want. Yeah, that'll make it *much* simpler! Link to comment Share on other sites More sharing options...
djgogi Posted July 30, 2002 Share Posted July 30, 2002 It's pretty simple. after creating found set in master file,gather all key fields in one global field (or by mean of creating an layout with only key field on it and performing script steps Copy All Records Paste [gField, select] or by defining an conditional value list that use the key field ) Now create auxiliary relationships vs your children files from gfield-->rightKey and perform GTRR step with option show only related records followed by perform external script (the export script that you would have to define in every child file) That's it Dj Link to comment Share on other sites More sharing options...
SteveB Posted July 30, 2002 Author Share Posted July 30, 2002 Dj: I'm confused about what you mean by: Now create auxiliary relationships vs your children files from gfield-->rightKey and perform GTRR step with option show only related records followed by perform external script (the export script that you would have to define in every child file) Steve Link to comment Share on other sites More sharing options...
djgogi Posted July 31, 2002 Share Posted July 31, 2002 her's an demo file Dj Steven.zip Link to comment Share on other sites More sharing options...
Lougee Posted August 23, 2002 Share Posted August 23, 2002 I know I'm tired and sleepy this AM, but I don't understand the difference between exporting the data and exporting the records. Explain please??? Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7915 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