I have created forms:

1st form:

Roof Type - which has different types of roofs we service in one field

2nd form:

Problem/Solution

Roof Types - lookup based on the Roof Type form

Problem - Field which is a common list of items we find based on Roof Type

Solution - Field which has the solution for the selected problem.

I have another form with the work order request. On this form it also has a lookup related to Roof Type.

I created a subform for multiple records with a lookup for Roof Type. I added the Problem lookup from the Problem/Solution form and a multi-line text box for the solution field.

I successfully got the Roof Type field on the subform to populated based on the input from the Roof Type field on the work order form by using On Add Record > row.Roof_Type=Input.Roof_type;.

Next I want to filter the Problem lookup based on the Roof Type. Once the user selects the Problem I want the corresponding solution to populate.

Please help.

Regards

Arlan