Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

What my wife wants is for a new record (or tuple, you know what I mean) to be automatically added to one of those tables when a record is added to the other table.

Rick Curtis - Tutorial 4 Add or Delete Child Records related to Parent Table This tutorial is a follow-up to Tutorials 1-3. If you haven't read the previous tutorials yet, please do so before reading ...