I have a query that is looking up past products. It is leaving off some results at the moment. I have figured out the why, but I am not sure how to fix the problem. The problem is the current criteria doesn't account for if there is no secondary product. The products are from the same table. So I have a copy of the product table and the current criteria that the secondary can't equal the primary. The primary is a user input taken from a form.
My question is what do I need to add to the criteria of the secondary product to account for the possibility of there not being a secondary?