We have a client that gathers data from their clients from a form and it is stored in an access database. There are 2 types of clients so we built the app using 2 tables. Now the clien wants to "keep a running total of the number of clients in both tables". To further complicate matters they want to be able to look up the client data using the auto ID. So if they have a client number (auto ID) of 187 we need to write the code to have the look up look in both tables. Customers do get deleted so that throws the number off for purposes of total clients. They DO NOT want all of the clients in 1 table. For the life of me I can't think of any way to do that and have it be accurate or not a huge mess. Anybody out there have a brain that's working better than mine on a Friday?