⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

auto-populate field from database if user select X number



Adriana
  • profile picture
  • Member

Posted 31 July 2015 - 01:32 AM

Hello All,

Can anyone help me on how to autopopulate field from database if user select X number?.Example:

 

Table 1

id

name

city(relational column)

 

Table 2

id

city

 

So if anyone select Peter then city field get updated with Paris only.

 

Thank you for your kind help


Paul Savostin
  • profile picture
  • Member

Posted 31 July 2015 - 08:38 AM

Hi! similar to dependant drop select but not sure cause dont understand how Peter relate with Paris...

incomprehensible logic for me


Amit Shah
  • profile picture
  • Member

Posted 31 July 2015 - 18:06 PM

Paul - its can still be achieved by using ajax query for on change :)... even without the dependancy :D


Paul Savostin
  • profile picture
  • Member

Posted 31 July 2015 - 18:23 PM

Hi Amit! Yes it can, but I dont understood even DB shema and what Adriana want to achieve :)