Question Credentialing Database Help!!! I'm Stuck...

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?

Cross posted at http://www.accessforums.net/showthread.php?t=73780

Please read this link for why it matters https://www.excelguru.ca/content.php?184

Or can you tell me if I'm going about this the wrong way and guide me in the right direction?

Click to expand...

1. The development order of an Access database should be Tables then Reports then Forms. No point making spiffy forms if you are just using them to throw your data in a hole from which it can never be retrieved. Set up your tables properly, then build reports to verify that you can get your data out like you need, then build forms to get data into the system.

2. Read up on normalization (https://en.wikipedia.org/wiki/Database_normalization). That's the process of properly structuring your data into the correct table and fields. Work through a few tutorials, then apply what you learn to your tables. Finally, once you have your structure, set up the Relationship Tool in Access and post a screenshot here so we can help verify it.