CF8 - Read data

Hi

My database table : user_information with 4 columns (id, name, email and matricule) I created a form with : Dropdown name, email text field and matricule text field.

In submit I have add read data (name: read_data2) I link the table name to user_information and Read type All matching records and behaviors I added Data merge

In Dropdown I have added dynamic option
Data source : {var:read_data2}
Option Value Code: {row:name}
Option Value text: {row:name}

Options : empty

I try to make the dropdown read the data from the name column of database user_information but dropdown don't show nothing. Any help please as my goal is to use the dropdown to autofilled the email and matricule

Thank in advance

Hello Max,

Thank you for quick reply. I have load the "read data" in the top of the form above the field and dropdown work very well. But how to make it autofill the other field like email and matricule when we select a value in dropdown ?