I have created hundreds of layouts (well it seems like hundreds :-) over they years for my company database. I need to know which layouts are using a particular field, is there a way to show a list of layouts that use a particular field?
You can find this in the Database Design Report produced by FileMaker Advanced. There are third party tools that can make that report easier to read, but even the basic DDR has a table where each field is a row and one of the columns lists the layouts.
If you have FileMaker Advanced, you can find it making html of Database Design Report.
Otherwise, there are design functions LayoutNames() FieldNames(), see help. There is no function like LayoutNamesHavingField(), so you'd want making custom function to get it.
Retrieving data ...