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 = 'Shpt. Method Code' ORDER BY p.ID ,pc.ControlName
Find page controls

Pages with controls equal to SHPT. METHOD CODE

Seq NoPage NumberPage NameControl Name
1201Job JournalShpt. Method Code Search
2311Intrastat JournalShpt. Method Code Search
34813Intrastat Report SubformShpt. Method Code Search
44816Intrastat Report LinesShpt. Method Code Search