PHPRunner 5.3 Build 7474.
In an add/edit page I have to filter a dropdown box depending on a value of another dropdown box.
The problem is I have to list (in the filtered box) also some values where the code have NULL value.
I try with an example to be more clear:
Table Company:
company_code
001
002
003
Table Product:
product_code | company_code
AAA | 001
BBB | 001
CCC | 002
DDD | 003
EEE | NULL
FFF | NULL
(it is just an example, it does not reflect the DB structure)
I need to filter Product by company_code (that is selected on the same add/edit page), but I also have to show the products with the NULL value.
Unfortunately I can't duplicate the product EEE and FFF for every company.
Is there a way to apply a filter like this?
I thought to use the WHERE clause on lookup wizard, but I don't have a session variable where the selected company code is stored.
Any help would be greatly appreciated.
Thank you in advance,
Andrea