Let's say I have 3 custom modules:

~ Landlords

~ Properties

~ Rooms

On the rooms form, there is a lookup field for a property that associates a room with a property. On the properties form, there is a lookup field for a landlord that associates properties with landlords.

Question:

Is it possible to create a set of dynamic pick lists on a potential form that would meet the following requirements:

• There are three pick lists fields: Landlord, Property, Room. Room is dependent on Property and Property is dependent on Landlord.
• The values for the landlord picklist is sourced from landlord records in the landlord module.
• When a landlord is selected, the property picklist field only displays properties that are associated with that landlord
• When a property is selected, the room picklist field only displays rooms that are associated with that property