Hello friends,
I have a question about an expression for a dynamic dropdown boxe.
First let me try to exlpain my case:
I have one table “KUNDEN” (means Customer in German) where I want to add Customers name and e-mail, but also
1 - who recommended the client (field REF1) and
2 - the recommender 2nd. grade (field REF2) → recommender of the recommender.
So these are two levels of recommendation and both fields are drop-down boxes.
I am able to create the 1st. recommender dynamic filled drop down box, but the expression for the second one is quite some complex matter for me:
As you can see on the picture
I need the expression for the REF2 Dropdown box. As an example: If I would edit the record from Magdalena Aydin, who’s recommender (REF1) is Christian Aydin, THEN I need the Dropdown box for REF2 be filled with only the recommender of Christian Aydin, which is Robert Aksan.
I really would appreciate you help with this expression in the Data Validty “Valid IF” field in the properties of this attribute.
Thnx.
Robert
Solved! Go to Solution.
Ah! Oops! I was thinking Initial value rather than Valid If, for some reason.
Try this instead:
SELECT(
KUNDEN[REF1],
([KUNDE] = [_THISROW].[REF1])
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |