I have been developing a 3-tier structure, that uses disconnected recordsets.
Basically what it does is that the server component gets data from the databse
(SQL-Server 7), puts it into a recordset, disconnects the recordset, sends the
recordset to the client.

The client can modify this recordset in all ways, change data, add data, and
delete data.

When changes are done, the recordset is sent back to the server component. the
server connects the recordset to a valid connection-object, and calls the
UpdateBatch function, wich saves the changes to the database.

This all works fine, except when I am using querys with joined-tables. When I
delete a record in a recordset based on such a query, and does a BatchUpdate
on it, It does not only delete the record from the "main table", it also
deletes records from the joined tables.

What I want it to do is to just delete the record from the "main" table and
not the joined ones.

Have you got any ideas on how to do this, or what I may have done wrong? I
need all the help i can get.

news-user.

Markus Hogsved