Is there an easy way to find which Detail screens contain a specific field?

Version 1

    Details

    Is there an easy way to find which Detail screens contain a specific field?


    Resolution

    The below query when run in SQL Server Management Studio will return a list of all the DetailTypes that contain a certain named Field.  Replace "Field_Name" with the name of the field you are looking to find.   SELECT TableName, TableType FROM HEATFld WHERE FLDName = 'Field_Name' AND TableName = 'Detail'