I've spent an hour trying to research how to solve this, and I'm hitting a wall because it seems so simple, yet I can't get the thing to work.
In form Component_Name there's a text field Component_Name.
In form Template_Name, there's a text field Template_Name and a field Component_List that's a multi-select of field Component_Name.
In form Page_Name, there's a text field Page_Name and a field Template_List that's a drop-down that pulls options from form Template_Name.
In form Data_Entry, there's a drop-down of Page_Name pulled from the form Page_Name. What I'm trying to do is create a pulldown of Components that are filtered based on the value of Template_Name from the value of Page_Name.
I think this requires using a fetch records to pull the value of Template_Name into the form, then use that to filter the drop-down menu. But every combination of criteria returns an error. I've attached a screen shot of how I keep thinking this should work, but I get this error:
Encountered "==" at line 1, column 1.
Was expecting one of:
"!" ...
"+" ...
"-" ...
Any help would be appreciated.