M
markmywords
Guest
I've read tinkers posting which I'm sure is the same problem but couldn't really get my head around it all.
Here's mine.
I have two combo boxes which select product types. The first is always selected and the second is sometimes selected. After a positive selection a Cost ID is returned into the query and the accompanying Unit Cost is used in an expression for a calculated field.
In the case of the second combo, when a product is not selected (a check box disables it) then I would like the calculated field to result in £0.00. Because there is no Cost ID and thus no Unit Cost associated, the expression just returns as null.
Do I need a Cost ID which relates to £0.00 Unit Cost which is then stamped into the query when no selection is made?
If so, how do I set this as the default in case of no selected product.
Here's mine.
I have two combo boxes which select product types. The first is always selected and the second is sometimes selected. After a positive selection a Cost ID is returned into the query and the accompanying Unit Cost is used in an expression for a calculated field.
In the case of the second combo, when a product is not selected (a check box disables it) then I would like the calculated field to result in £0.00. Because there is no Cost ID and thus no Unit Cost associated, the expression just returns as null.
Do I need a Cost ID which relates to £0.00 Unit Cost which is then stamped into the query when no selection is made?
If so, how do I set this as the default in case of no selected product.