Greetings All
I have a situation where I have 2 transaction components on a form
with different query and datasource components linking to each because
I want to keep the queries for each transaction separate.
The thing is that when i try to insert on one of the queries the
status of the other transaction (the one the query is not using)
changes from Inactive to active. This shouldn't be as far as I can see
because the query isn't using that transaction, it even makes no
difference if I have separate connection components for each of the
transactions. why is the separate transaction being affected by things
that should be unrelated?

cheers