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.