>This is 1-M Relationship.
>
>Table2 - Parent Table. Field1 is PK field. One record for each Field1 PK
>Table1 - Foreign table. Field1 is a Foreign key. It could have several records for the same value of Field1.
>
:) Usually I would think in reverse that's why it was a bit confusing.
Now, back to the original question - which rows of Table1 do you want to get per single Field1 (PK) in the table2 ?
If it's not broken, fix it until it is.
My Blog