I have an inner-active form created in Adobe livecycle 8. It connects to an SQL database. I have a drop-down list that shows me the customer name and i enter the name I want into the form field.
I want the form fields address1......address2......city......state....and zip to popultae with the coresponding data from the datbase table. I cant seem to get it to work.
Just to be clear: I already have a connection to a SQL database. It works fine.
I have a name address1 address2 city state zip fiels in the SQL table
I have a name address1 address2 city state zip fiels on my form.
I want a select name dropdown list that will show me the names in the database and let me select one.
After I select the name, I want the name address1 address2 city state zip fields on the form to populate.