query help. its duplicating values erg!

[mcamp]

Ok so I have a query

table A contains all those children who signed into class. who are considered to be receiving "Direct Service"

Table B contains the entire families associated with those children- siblings who are considered to be receiving "Indirect Service"

all connected by FamilyID

Table A has a field called DirectSvc with a default value of 1, as everyone in it is receiving direct svc

table b does not have this field

when I run the query, it is copying down 1's in the 'DirectSvc' field for all children when there should only be 1's on those children from table A, as they all have 1's associated with them. all children from table B should be yielding a null or blank value as that table does not even have this 'DirectSvc' field.

why is it copying 1's down for everyone? I cannot seem to figure it out, and now I have no way of determining who is receiving direct svc and indirect svc, which is the whole reason for the query.

help please! thanks!!!

 

[mcamp]

is there some way I can pull everything from table B thats not equal to table A??

IE.... Table A........Table B...........qy recordset
.......John Doe ..... Marry Doe ........ Marry Doe
..........................John Doe ......... Bob Doe
...................... ....Bob Doe

then I would know all those in that query had 'indirect service' and could assign them values of 0

?????????

 

[boblarson]

See if this helps:

http://www.btabdevelopment.com/ts/tbl2exclude