Need to lookup multiple Products for same customer?
I have a "Sales Funnel" database where I list all the products a customer may be interested in (Product1 through Product4).
To do this, I created a "Product" Table which lists the available products and a "Sales Funnel" Table which is supposed to display up to four different products of interest per client. The "Product" Table is related to the "Funnel" Table by "Product Name" (the match field). I have been able to create a lookup for one product per client (Product => Product1), but If I try to add a second Product (Product => Product2) it all collapses. Nothing works.
How can I use the one Product Table to provide data for my Sales Funnel with 4 possible products per client using a lookup?