Current(), Preceding Not Working

B

BJ

I am trying to use the formulas Current() and Preceding in my filters so that
I can have unique values in my drop downs and in a repeating section. I
can't seem to get these to work....it may just be my syntax but I will give
you my schema. Hopefully someone can tell me what the correct syntax would
be.

Main Data Source
-myFields
--queryFields
--dataFields
---d:GroupA
----FieldA1
----FieldA2
----FieldA3
----GroupB
-----FieldB1
-----FieldB2
-----FieldB3

Secondary Data Sources
-GroupB
--FieldB1
--FieldB2
--FieldB3
-GroupC
--FieldC1
--FieldC2

I have a series of three drop downs. The first is a list of values from
FieldC1 of my secondary source but is bound to FieldB1 of the main
datasource. The next drop down is a list of values from FieldB2 of the
secondary datasource linked via FieldB1 and bound to FieldB2 of the main
datasource. The third and final drop down is a list of values from FieldB3
of the secondary datasource, linked via the previous two dropdown boxes and
is bound to FieldA1 of the main datasource. Any thoughts on how to insert
filters with Current() and preceding on these list boxes to keep values
distinct and keep values specific to their section?
 
Top