Need help defining the relationship

[ewong]

Check your field names, make sure the spelling is correct; verify against the table definition.

Hi orange,

It works fine now, it seems



Anyway, I have another questions. I tried doing this before by going through it "manually". Instead of using sql, I went to the query design, added both tables in the 'show table', and added all the fields from table 1 + commission id from table 2. It seemed to generate the same result with what I have now using the sql method. I am just curious if this is really another way of doing it besides using sql...

Another question I have is, while it's working, there seems to be something odd with the amount of data it currently has. The new report seems to have lost 10 rows of data...

Do you have any idea of what might have happened?

Thanks!

[orange]

The query wizard is the interface that humans (often non programmers) tend to learn and use. Behind the scenes the query parameters are transformed into SQL and processed by the database engine.
Whether you use the wizard interface, or use the SQL view directly is up to you. The result should be the same regardless of which you use.

Your query is only picking records where the the fields in both tables are equal.

You should investigate w3schools.com for SQL queries. Look at the different types of Joins

Inner Join Left Join.. and see what they do.

Good luck.