I am creating an insurance credentialing database for my facility that tracks all of the insurance plans our providers are credentialed with. We have 34 providers, 7 locations, and 232 active insurance plans. Each provider is credentialed with different insurance plans at each location. I need to be able to track that in the database. The way I currently have it setup is I have a Provider List TABLE and within that table I have a columns for the provider names, their credentials, and their ID numbers. I also have 7 additional columns for our 7 facilities. Each of those 7 additional columns is labeled with a facility name and is a LOOKUP FIELD that relates back to a separate table with all 232 of our active insurance plans.
From that TABLE, I created a FORM with each of the providers (34) listed separately. On each provider form I put a TAB CONTROL. Each TAB CONTROL has 7 tabs for each of the facilities. What I wanted to happen with the TAB CONTROL on the form is that it would list out each of the insurance plans that the provider is credentialed with at each facility. I also wanted to make each of the names for the insurance plans a hyperlink that can be clicked on and will open a second form with all of the contact information for that specific insurance plan.
My roadblock is that I can't seem to figure out how to make what I want to happen with the TAB CONTROL on the form...happen. I actually don't even know if it is possible. Can anyone provide any assistance with this? Or can you tell me if I'm going about this the wrong way and guide me in the right direction?