Provider/Customer Hub help!

[cballew]

So I work in the health field and I have a database I'm trying to add a feature too. Essentially I have three tables, Providers (customers for our purposes), Calls, and Authorizations (records of approval for services). What I'd like to do is create form called something like Provider HUB where you would be able to edit the provider's information but also on the same form you would have it sectioned out to have a list of all calls associated to the provider in one section and all authorizations associated to the provider in another. The calls and authorizations would be clickable so that the user could quickly go to a call or authorization review form (already built) quickly. I'm having difficulty doing this. I know I could create a datasheet form for each calls and authorizations and just have the users navigate to a different form to be able to access the records of the chosen type but I'd really like it houses in one spot. I had thought to do a list box for both calls and authroizations but am having trouble making it click and go worthy and also pulling the right information as it is pulling a relationship from multiple tables (for instance calls list would show only calls with the field provider name matching the field provider in the providers table).



Any help would be great and highly appreciated!

Thanks!

[pbaldy]

You could have 2 subforms on the main form. Master/child links would keep them in sync (the wizard will set that up). You can use this for the chosen record:

http://www.baldyweb.com/wherecondition.htm

[cballew]

That worked perfectly! Thanks!

[pbaldy]

Happy to help and welcome to the site by the way!