Thanks in advance for the help,
I have two tables:
Table A (Sales_Details),
Table B (Products)
And I have a Slice, from Products, and the row filter for the slice is “Product Active = TRUE”
There is a ref column in Sales_Details to Slice_Products, it works perfect, when I try to add a new sale, the dropdownlist shows only “Active Products”; but the problem is, when I search for old sales, there are many sales with products that maybe, in this moment are Inactive, so, in the Sales_Details View shows only the ID, just because the Product “doesn’t belong to Active Products”
Maybe someone of you, could help me, thanks in advance.
Solved! Go to Solution.
You need to have your Ref column point to the base Table, not the Slice.
You can still limit the dropdown list by using a valid_if expression if that is necessary.
You need to have your Ref column point to the base Table, not the Slice.
You can still limit the dropdown list by using a valid_if expression if that is necessary.
Thanks @Marc_Dillon !!!
User | Count |
---|---|
41 | |
25 | |
25 | |
17 | |
12 |