Query Duplicating Data

[Nero]

Hi,
I posted a topic a few days ago but I didn't explain it very well.
The problem is that I have a query based on 4 tables. Each table has 14 records.
When the query is run I would expect it to show the data I need in 14 records in the query.Instead it is showing 38016 records in the query.
Can anyone please help??

Thanks,

 

[Nero]

Thanks Pat,
That has done it.
The only problem I have now is that these 4 tables are deleted once the query has run.The next day 4 more tables are imported and the process continues.Once the tables have been deleted the relationship cuts.
Is there a way of automatically restablishing the relationships?
Thanks again for your reply.

 

[Nero]

Thanks for your help Pat.
Problem solved!!