Dear Helen,

I am not sure if I can ask this here. I have several tables for my new project. I have had several one-many relationships. Somehow there is a relationship between tables which is one-one i guess. I have not created this relationship, may be, access created this automatically since this relationship is trasitive.

When i include the one side table of the relationship my query does not output any recordset. however, i was once able to use these tables in my query to output recordset successfully.

i want to know whats is the way to resolve this problem. should i use sub query. Access error message told something similar once but not again and I forgot to note down the details.

thanks in anticipation.
br karthick

CJBGUY

__________________
CJBGUY