Hi,
I am creating a database with our client's records. I initally imported the data using two different tables "ActiveClients" and "Inactive Clients" I have created a form to add clients to the Database however, I am wondering if I have added the "Active" and Inactive" fields which contain dates, will Access move the one client from the Active table to the Inactive table?
Should I just have a single client table containing active clients and inactive clients? If so, how do I keep the inactive clients hidden when i "flip through" the Form pages?
I'm very new to Access and desperately trying to get this to work for my boss.
Thank you