Hi guys,

I am trying to get all of the clients out of a database table where that client has an entry in the accounts table AND that entry is of a type Workers Compensation. I have this working rather nicely. HOWEVER I have 2 questions that go along with this:

#1 I get everything EXCEPT the clientID. How do I get the clientID to come with the rest of the information?

#2 I am taking the client information and putting it into a combo box ..... then I want another combo box to populate with all the account information related to the client the user clicked on in the first combo box. Is there any way to do this with one recordset?

Matt