one to many relationship? need help please

uatkd1

New member
Local time
Today, 01:00
Joined
Dec 19, 2011
Messages
8
I have two tables in a left join and i have one set of numbers that has multiple matches of a different set of numbers. For example:

Qpin Lpack number (primary Key)
9555 95555555
9555 95555555
9555 95550000
9555 95550000

The table on the right has the multiple Lpack numbers and the table on the right has the Qpin numbers. Do i need to do an expression or perhaps break it down into more queries/tables?

This is the expression I used and it did not work
IIf([table name tbl.lpack]=[table name.lpack] And [table name.opin]=[table name.opin],"yes","no")

it gives me this result:
Qpin Lpack number (primary key)
9555 95555555
9555 95555555
I need a way to flag all of the Qpin numbers that have different Lpack numbers...Would an expression work, and if so what? grrrr this one has FRUSTRATED me! Thanks guys.
 
What you have and what you want is confusing. Please post sample data of both your tables in your query, the SQL of your query, what you expect your results to be from the query based on your sample data and what you are actually getting from your query.
 

Users who are viewing this thread

Back
Top Bottom