Is this the scenario?
You select a "category" type value in field 1, but when you open the popup menu in field 2, the conditional value list doesn't work unless you commit records before popping up the menu?
If so, set a script trigger on the first field to commit records automatically. Depending on the field format of the preceding field, that might be either OnObjectModify or OnObjectSave.
Thank you Phil,
but i can not commit the record as it will trigger other fields "not empty" validation rules.
i noticed that this does not happen using Filemaker Go, only using Filemaker Pro on my MAC.
i can use commit record script and check skip validation, but that will make it a modified record, or am i wrong?
That will leave the record as "modified", but validation field options--which can be a bit "clumsy", are not your only options for making sure that required fields receive data.
And what you describe is not typical of a conditional value list. So there is some factor to your design, and I don't think that it's the validation rules, that is needing that commit before the conditional value list from working.