Exporting Selected Tables Only

[jimkent]

I have a DB with 5 tables full of test results for a record (StudentID). These students (as a batch) only took two or three subjects (each subject is a table). I'm trying to have the teacher (using FM) choose which table to export for the batch of students. i.e. If this batch of students only took math and English, I would like an export only to export the Math and the English table. Not the Social Studies, Science and History tables. Is there any easy script process to do this?

If I create and export records and choose all the fields of all the tables, the student will have fields associated with subjects He/She has nothing to do with.

I can try multiple exports with a few global variables as checkboxes, that can trigger associated tables to be exported (one table at a time) but is there a way (in windows) to do a merge of those files after that type of export? I know we can merge by adding the records to the bottom of a record set but I don't know if one can add fields to the "right" of each record (or append to each studentID more fields). Am I making sense?

Thanks.

[comment]

Why is each subject a table? That doesn't sound right. These records should be in the same table, with a field to indicate the subject. Then your problem will go away.

[jimkent]

Yep, but it's an old DB and they don't want me to change it. (go figure). I could have a case statement that goes through all cases that would be a case statement with 120 different exports (I have 5 subjects {5!}). Any other thoughts?

[comment]

You would need to use either a plugin that can append to a text file, or OS scripting (VBS on Windows, I think) to concatenate the files.

Or you could import the records to a "batch" table and export from there - but then why not do this all at once and be done with it?

Edited May 16, 2008 by Guest