Page Control Search – Dynamics 365 BC Table Reference

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 = 'Service Shelf No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to SERVICE SHELF NO.

Seq No	Page Number	Page Name	Control Name
1	5902	Service Order Subform	Service Shelf No.
2	5906	Service Item Worksheet	Service Shelf No.
3	5915	Service Tasks	Service Shelf No.
4	5965	Service Quote Subform	Service Shelf No.
5	5976	Posted Service Shpt. Subform	Service Shelf No.

Dynamics 365 BC Table ReferencePage Control Search