I have a report that display client meetings and supervisors notes. I have two combo boxes on a search and report form, one is clients and the other is supervisors. I want to select the supervisor and only his assigned clients show up in the combo box under clients.
I have each combo box as a lookup table and the client name is being pulled from one table and the supervisor name is being pulled from another table. How do I have it where it only shows the supervisors clients in the client drop down?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
khale
Hi,
I have a report that display client meetings and supervisors notes. I have two combo boxes on a search and report form, one is clients and the other is supervisors. I want to select the supervisor and only his assigned clients show up in the combo box under clients.
I have each combo box as a lookup table and the client name is being pulled from one table and the supervisor name is being pulled from another table. How do I have it where it only shows the supervisors clients in the client drop down?
Thanks
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.