Speeding up scripts

[fed]

I have a script that finds related fields in various tables in order to make a summary report in text format. It is getting rather slow now that the amount of records is increasing.

I think that a main issue is that whenever I do a search to find the related records in related tables, the window is drawn. I have tried to Hide the window, but it still shows up and likely slows the script.

Is there any way to prevent the window from opening in the first place?

Thanks,

Fed

[Søren Dyhr]

Use the relations to establish the queries to the other tables, not scripting. With this established, is scripting beyond fm9 hardly any more than going to the approapriate layout for showing the reporting. The matter takes place in a join table since it's usually the most atomic.

This might prove tricky if the solution isn't appropriately normalized though?

--sd