Unanswered: automating import from source through a form?
Is it possible to automate the import from "some" relevant data source into the db THROUGH a form, to ensure that all the testing etc. already existing for each of the form fields takes care of the validation of the imported data?
ok, I understand that I can program something to fetch data on the form_load/form_current events, populating each field and saving, but are there other ways? What would require the least effort? For example redirecting a query output to the form, mapping columns to fields (putting the data "on top", not filling the fields from "underneath"...
Hmm, maybe this is just a stupid question, but anyway, taking the chance ;-)