Hi,

I have a query function which is held in a module and can be utilised by many other procedures, the data returned is held in a single dataset which is overwritten by subsequent queries.

In some instances I need to keep hold of the information for further manipulation. The datset object has several copy / clone type functions but I cant find any information on how to use these.

Any advice would be much appreciated!

Dear All,

I have figured out the solution, and its easier than I ever imagined. For everyones reference the solution is as follows:

(This assumes the first dataset, ds, is already populated, Model is simply the second datatset)

Basreference.Model = ds.Copy