Hi Laura,

I suspect this is working, just not as you expect.
If you just type an 'L' into the street field you will get the first L value from your table, just as you see.   You can then select the L street from the drop down list.

OR if you keep typing (rather quickly) the first few letters of the street name it will start to narrow down the choices, to the point the street name is unique in the list.

Once you have a unique street name the rest should fill in.   Unless there is more than one address/legal entry for that street in your database.  At that point you again need to specify (or type) in the address/legal field.

Basically you need to keep specifying information until there is a unique entry in the database, at which point the remaining fields will fill in.

For example on our HR template,  if I type S into the last name field, I get the first entry Saade.  If I type Saxton the rest of the fields fill in since there is only one Saxton.    If I were to type Smith, I would then have to move to the first name field and select which Smith, since we have multiple Smiths.

The setup you posted looks as if it should be working, possible there is an issue but hard to know without seeing your tables.
Hopefully that helped or take a peek at Dynamic Fields in the reference manual.   They are great when the work!!