Skip to main content ↑ ↓
Topic: client events sql statement (Read 913 times) previous topic - next topic

client events sql statement

Hi All!!
 
I have select field emp_id from my employee table ( emp_id, name, city )

how i can set name and city to textbox when i choose select field (combo box) emp_id?

please help i still learning in phprad

Re: client events sql statement

Reply #1 –
@cnmycrl‍ please use the Action Before Add in Page Event to query the record using the id from that select field, and then, use the result to assign to the name and city field, and it will be inserted to your database table.

Re: client events sql statement

Reply #2 –
Thanks!! I will Try it

Re: client events sql statement

Reply #4 –
Hi, phprad does not have the auto fill, what phprad have is auto-suggest. The closest to what you want would be using Page Events. You will have to disable the fields and then on Action Before Add in Page Events, you run a query to get the data you want using the data from no KP field. If you need help with doing that send me your anydesk ID. 

Re: client events sql statement

Reply #5 –
Quote from: willvin –
@cnmycrl‍ please use the Action Before Add in Page Event to query the record using the id from that select field, and then, use the result to assign to the name and city field, and it will be inserted to your database table.
Hi Willvin,
have you got an example for this? Ho w can I use the resulting fields in the email?
TIA
tony