How to select from drop-down menu connected to SQL database and then autofill?

[star_cookie_que]

Hello,

I am in the process of creating a series of forms and I need some help if working out how to do the following.

I have already set up a data connection to an SQL database, and I have three fields connected: Job Number, Job Name and Customer Name.

What I want to do is have it so that the Job Number is a dropdown box, so they can select the number, and then the other two fields, Job Name and Customer Name, are autofilled to the information corresponding to the Job Number.

Is anyone able to help me do this please??

Thank you!!

[radzmar]

The 101 of database connections from LiveCycle Designer can be found in Stefan Camerons blog.

This is the right place to start.

http://forms.stefcameron.com/2006/09/18/connecting-a-form-to-a-database/

http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

http://forms.stefcameron.com/2006/10/12/displaying-all-records-from-an-odbc-data-connection/

[star_cookie_que]

Thanks radzmar... I've actually already tried that and it hasn't helped me, his examples are great and helped me get to where I am at now, but I can't seem to 'change' things enough from his explain, to how I need it to work to make it functionable

.... Posting on here was kind of a last resort

So if anyone else can help me with my problem, I'd really appriricate it?

Thanks