Remove records from recordset without deleting them from database

[quote=236478:@Dave S]But no tool on earth (free or otherwise) will help you solve a problem unless you have a clear understanding of the problem.

None of these tools will solve that little issue for you. :)[/quote]
navicat has an integrated graphical query editor that helps a lot in forming a correct sql select among many related tables.
but it’s $700…

[quote=236485:@Jean-Yves Pochez]navicat has an integrated graphical query editor that helps a lot in forming a correct sql select among many related tables.
but it’s $700…[/quote]
That’s if you buy the version that does ALL databases. Considerably cheaper if you buy just a single database.