Page Control Search

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Qty. to Assemble to Order' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to QTY. TO ASSEMBLE TO ORDER

Seq NoPage NumberPage NameControl Name
146Sales Order SubformQty. to Assemble to Order Search
295Sales Quote SubformQty. to Assemble to Order Search
3508Blanket Sales Order SubformQty. to Assemble to Order Search