combine a service table with an intake table

[daisy]

i have a service table that asks for client name, client number, service
date, type of service, outcome, length of time you met with client, and case
manager. the intake table has name, age, gender, ethnicity, income, handicap,
language, citizenship, number of people in the household, date of birth and
gender, and other things.

The query i need asks for info on old clients that i would only get from the
first service date. i need the old client's info with name, age, gender,
ethnicity, income, handicap, language, citizenship, number of people in the
household, date of birth and gender. When i put the two queries together i
get a mismatch which i don't understand how to fix this. there must be a
confusion with the service dates and intake dates because the person not
necessarily is new for that period of time. please help!!!

 

[Darrin]

It seems like it would be much simpler if the table filtered the results you
were looking for by the client name ir number then the rest of the
information would fall into place.