My problem is: When I use a SQL query to pull ALL the data from 2 tables; HOW do I then turn around and save the relevant info BACK to each specific table??
i.e. Fields 1,3,5 are pulled from Table 1,
Fields 2,4,6 are pulled from Table 2 in the SQL query;

When the user is done, how do I code to get the results of Fields 1,3,5 back INTO table 1, and 2,4,6 INTO table 2 in the Database??
I'm figuring I have to code all this(that is, no easy way out <g> ). Also, what if I want to save the query as a .ADTG persisted file-can we do that with 2 recordsets going into 1 file?? Thanks for any help!!