Hi There
I have 2 tables : Products and Orders
In Products table I have a field named ACTIVE, in order to select only products that are still in use...
In CHILD LOOK UP fields I´m using the field ACTIVE in FILTER. If ACTIVE = 1, it should list all products, if ACTIVE = 0, then should not apear...
It works, but all orders that have products with ACTIVE =0, in LIST panel does not apear the product name anymore, but its ID instead...
How sould I fix it?
I want :
- In LIST panel, product name should apear even if ACTIVE = 0;
- In ADD panel, product name should apear only if ACTIVE = 1;
Any Idea?
Is it possible to arrange in cascade mode?