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 = 'Usage (Total Cost)' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to USAGE (TOTAL COST)

Seq NoPage NumberPage NameControl Name
11001Job Task Lines SubformUsage (Total Cost) Search
21002Job Task LinesUsage (Total Cost) Search
31028Job WIP TotalsUsage (Total Cost) Search