How to update other fields when the select field changes

Applications Forms
#1

Hi,

Please help, I need to update some fields in a form from the id_customer as adress, phone, etc.

The data of customer is in other table called customers, I need to lookup in the customer table from the id_customer in my form, how can I obtain the data from customer table and how can I update the result in my form to be updated in other table.

Thanks in advance,

Eduardo Cazares

#2

The lookup can be created by a simple link (link -> caption link). Then after selecting the value you can use an ajax event to perform a select on this key to retrieve and veiw the other data. Since the onchange does not always fire I advise you to use the next field for this trigger too.