I am currently working on an Access dbs for work. I have been thinking about how to do for awhile and still haven't figured this out (I am also somewhat of a newbie to Access).
The dbs is comprised of 18 tables including junction table. The main tables in questions are:
Request which has a M:M relationship with Client
Client which has a 1:M relationship to Program
What I am trying to do is in the Request form have a client subform where multiple clients can be associated to the Request
The subform is based on a query with Request, Client, Client Request junction
has the client, program fields
What i need to have done is for the user to be able to select the client from the client list box and then the program list box to be defaulted to a program associated with the client. If more than one program under the client exist then the user can click on the program list box to select the appropriate program associated with the client. The list box at this point should only display programs associated to the client. At the same time, the user should also be able to select from the program list box and then automatically populate the client info -- meaning the user have two ways to populate these two fields > via program or client
I believe VBA is the way to go since there could be two rowsources for Program Id listbox.... I tried various codes i can muster, but none worked.
Any help on this would be great.
Thanks!