table relationships and select statements

[wjulaxer13]

I have coded a select statement that uses multiple tables for information used to populate a report. It returns the correct information, sort of, but it doesn't recognize the already existing table relationships so I get dupicate records. Is there a way to run the code so that it recognizes the table relationships? thank you

 

[plog]

but it doesn't recognize the already existing table relationships so I get dupicate records

This sounds more like an issue with you not understanding the relationships of your tables. Queries are just logical code, they return the results they are told to.

Can you post some sample data? Perhaps post your database and then also post a spreadsheet that shows what you expect to be returned by a query.