Multiple table extraction based on a filter

[GraemeG]

Hi,

I have 10 tables all with the same amount of records (will eventually be 12000+) based on a KeyReference but with different fieldsets.

I need to be able to set a filter, using the KeyRefernce, on all the tables at once to show the one particular record in each of the tables and then extract the tables to CSV files on a server address. (Prefereably all done in the background from a command button so the user does not see this happening once they have selected the record they want)

Is this possible?

It would be very much appreciated it someone has the answer and method for this.

Thanks