I defined a junction to link 4 tables together using foreign keys. My query, based on the junction table, looks like this:

ID, product1_ID, product1_Name, product2_ID, product2_Name, . . . , Remark
The product ID are not displayed.

I need to select by product1_Name. So far, I can select by ID or by Remark but can't select by product names.

There is probably something simple I just overlooked. Can somebody help? Thanks.