(Sorry this is so long, was trying to fully explain the situation) There are two tables that handle information on our clients. Every client has a unique ClientID, and the ClientID is the Primary Key for the records.

I have a query that displays fields from both tables, but while one of the tables, the main one that hold the Contact information has ALL of the clients in it; the other table holds additional, optional information, so...