query

L

Layla

I have a query with a many to many relationship. The
tables alone with no relationship can return a data. But
once I have the relationship. Data is not returned. Does
anyone know why? and how I can fix this?

Thanks
 
J

John Vinson

I have a query with a many to many relationship. The
tables alone with no relationship can return a data. But
once I have the relationship. Data is not returned. Does
anyone know why? and how I can fix this?

Thanks
Click to expand...

A Many to Many relationship always requires a third table to contain
the relationship information itself. What is the structure of your
Tables? Could you post the SQL of the query that's not returning data?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Append Crosstab Query to Existing Table 0
Can't see existing table in Design view for a QBE 6
How to have two tables on same line? 1
Query joins not created in front end query grid 2
Query question 2
Non-code solution 11

Top