Let's say I have three custom objects: Neighborhood, House, and Room. On the Account object, I have lookup fields for these objects.
My goal: When the user selects a Neighborhood, I want ONLY the houses contained within that neighborhood to be available for selection in the House field. After a house is selected, I want ONLY the rooms contained within that house to be available for selection in the Room field. Is there any way to do this?
I have already learned that there are ways to do this in a custom Lightning page. However, I'm looking for a way to do this with custom fields on a regular Salesforce object, like Account.