I am using MS Access 97 & have a form with two look up fields (Client List and Matter List). They both look up values from a separate table. Each record in the separate table contains a Client Number and Matter number.
The user will select a "Client" number & then I would like the "Matter" drop-down to list only matters for that Client.
Generally - they are 2-5 "matters" per "client". I have read through a lot of posts & found similar questions but still not sure how to do this.
The user will select a "Client" number & then I would like the "Matter" drop-down to list only matters for that Client.
Generally - they are 2-5 "matters" per "client". I have read through a lot of posts & found similar questions but still not sure how to do this.