hi.. i have 2 column
column 1 .. group name
column 2 .. members name
when click group name... column 2 will show group members selected only,, and use Enum list ... but the problem is error message show "this entry is invalid" when select data
Do you have "Allow Other Values" checked? If not, that is your problem. Just make sure you still implement a valid if condition or suggested values.
tq for reply.. i have done checked allow other value, ... as photo below... column " nama guru bertugas " refer to column " nama kumpulan bertugas"....
Do you have a valid if condition attached to that column? If so please show what it is.
tq for help... i show the picture...
You will need to change your valid if to something else. Possibly eliminate it all together and just set your suggested values setting. You are essentially saying under the valid if that the value is only valid if the selected values are equal to that entire list of values stored in that table and under that column.
I had a valid IF statement, but I removed it, and it worked. Before, with the valid IF, it was showing "this entry is invalid."
Thanks
User | Count |
---|---|
29 | |
13 | |
3 | |
3 | |
2 |