Hi guys
with a lot of help from this forum - thanks once again ! ![](/legacyfs/online/emoticons/happy.png)
we have got our form connected to an online database, and have got around the "not trusted" failures we were having.
what we are looking to do, and hopefully someone has done something similar (ie a bit of guidance would be great) is to have the user enter
their id into a form field, and have that id correspond to their database record, and somehow trigger on the exit event a call to the database so that all database fields are read, and every correspondingly names field in the form is populated.
our test database is very simple - it has id, firstname, midmane and lastname (and a hashed password field used in our submissions routines we dont need to worry about here)
i dont really know how, but i guess i know what, which is something like ---on id field exit event - for each field in id record that = a fieldname in this form, import value of field in database record corresponding to id and insert in correspondingly named field in form
if anyone has a code sample, any good books or demo's please point us in the right direction
thanks in advance