Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    20

    Angry Unanswered: Pull from IDs in Query to Show Names

    Okay, what's the best way to do this:

    I have a database with one table that has client information (TBL_CLIENTINFO) and another that has provider information (TBL_PRVS).
    Each client can have up to six service providers so there are six fields in their client record and six corresponding provider tables (TBL_LEADPRVS and all of the TBL_SECPRVS)
    Each provider has an ID number.
    The provider ID fields in the Client table and Provider table are linked.

    I want to be able to show all of the clients with their service provider's names on a report (RPT_CLIENTSERVICES).

    I tried to link them via a query (QRY_CLDATA) but when I do it knocks out some clients from the results.

    Any ideas? The database is attached as a Zip. It looks like a mess. Thanks!

    --Tom
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I can't d/l your database from my current location, but I can already tell you there's a schema issue. If each client can have up to six providers, than that information needs to be stored in a seperate table.

    ie:

    tblClient
    --------
    client_id
    fname
    etc

    tblProvs
    ------
    prov_id
    prov_name
    etc

    tblClientProv
    -------------
    client_prov_id
    client_id
    prov_id
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •