Results 1 to 2 of 2
  1. #1
    trumirage is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2018
    Posts
    10

    Exclamation 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?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Cross posted in another section of this forum and at https://www.access-programmers.co.uk...=1#post1592116

    User has been advised to read standard Excelguru article about crossposting
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-10-2018, 09:39 AM
  2. Stuck on complex Quote/ Order Database
    By Mbroeth in forum Database Design
    Replies: 2
    Last Post: 12-11-2017, 07:38 PM
  3. I'm stuck
    By tc197 in forum Access
    Replies: 14
    Last Post: 07-07-2014, 07:12 AM
  4. I am stuck!
    By asaloba in forum Database Design
    Replies: 9
    Last Post: 02-29-2012, 12:47 PM
  5. Can anyone help please... I am stuck
    By Casper2012 in forum Forms
    Replies: 7
    Last Post: 08-15-2011, 11:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums