I am basing the lookup rules of one form on the rules from another form so that they behave similarly.  The behavior I am looking for is to choose only active employee records, and based on selection of location, populate the name and title drop down fields for employees working at that location.  Then based on selection of employee name, specifically populate the title field with that employee's title.

My original form chooses only active employee records, and based on selection of department name, populates the name, title, and location drop down fields for employees in that department.  Then based on selection of employee name, specifically populate the employee number, title, etc for that employee.

My original form has AutoFill buttons for both the department and name fields that populate the remaining fields correctly.  If I enter a name that is not currently in the database (say a new hire) I can still see the location and title information related to the department selection that was made using the first AutoFill.

My new form does not present with a second AutoFill for the name field and blanks out the title field that was populated by the first look up for location.

Why when the rule logic is similar, does the form act differently?  Images of lookups attached.