I have a data collection with a list of names and last names.
one of my pages is form and one of the form fields is the names from the database, that form is updating another database.
I'm taking names from database x and inserting them into database y, in database y there is names and other stuff from the submission form.
my question is, when user is picking the name from the drop down menu and updating the form fields, how can i fetch automatically the last name from database x and insert it to database y?.
when user is picking first name and hit submit, the last name will be updated as well between the data collections, is it possible?.