I have unexpected results when searching in a field, and I suspect it is because the field was mistakenly placed in a portal in another layout. (I may have done this myself some years ago.) Is there a way to search the database to find any layout where that field appears?
The next question is, how do I delete extraneous data from the field? The field should not be in a portal - data is stand-alone, not related to other history, and should not have multiple records. If I delete the field from any portals, will it automatically delete extra data which used to be in other portal rows, or how do I clear it up?