Hi,
Need some help with parameters.
Table "A" has a list of Sales orders (Header details)
Table "B" has the row data for the Sales Order(Row detail).
--Table "A" and "B" have inner join on Sales Order number.
--Table "B" includes the product codes sold.
Table "C" is a list of all products held by the company.
I want to use table "C" as the parameter input data.
If I use the products codes in "B" the data is restricted to sold product.
Is there a way to show all product codes in the parameter input?
I have tried adding table "C" with no links but get warning message.
Kind Regards,
Eric