Thank you Jason, I'm no MySQL pro for sure, this is my basic structure.
Each Table has a clientid associated with it to help with joins.
states.clientid (states offering services in - multiple rows)
clients.clientid (client contact info - single row)
languages.clientid (languages spoken- multiple rows)
courses.clientid (courses offered- multiple rows)
(formstate=states.statesid and states.clientid=clientsid)
Repeat recordset to display all matching results.
I don't expect you to crack this nut for me, but perhaps this additional detail will clarify things. I will read up on joins.
Thanks again - Jerry