Hi,
In a row I have two enumlists of the basetype ref. both refer to the same table.
Is it posssible to make sure that in the enumlists values which are selected in the other list can't be selected anymore?
I tried NOT(IN([Clubkey],[_thisrow].[Clubkey]))
Solved! Go to Solution.
Just try:
SPLIT(List(clubs[ClubKey]),โ,โ) - [ClubKey]
If it doesn't work, please show your table columns.
I still can't get it working..
SPLIT(List(clubs[ClubKey]),โ,โ)
- List([_thisrow].[ClubKey])
works, but not onchange on the form. So it only looks at saved data
Just try:
SPLIT(List(clubs[ClubKey]),โ,โ) - [ClubKey]
If it doesn't work, please show your table columns.
SPLIT(clubs[ClubKey],โ,โ) - [ClubKey] should be sufficient, without LIST().
Oh yes. Thank you @Steve !!
BOOM! thanks this works!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |