I have a form with a repeating table. One of the form fields is Park. The entire form is auto-populated by required field Work Order Number. All other fields are read only. The query for the repeating table should only bring back list rows where the Park column of the row in the data source matches the Park pushed into the form Park field at initial query.
I have written the following expression for the query. Is it close? Can it work? Please advise.
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
my:fields/my:AllWorkOrdersPageSection/my:WOPark!= "how do we direct the query to use the contents of the form Park field?"
Main (and secondary)
myFields
(Numerous Fields Here)
Folder: AllWorkOrdersPageSection
WOPark
WONo
WOLocDesc (etc)