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!
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.