I need to know if the following scenario is possible:
Table1 (Field1, Field2, Field3)-> [Form1]
Table2 (FieldA, FieldB, FieldC)-> [Form2]
Creating/Editing record of Form2
When finish to typing a new record’s FieldC value*, application will automatically check if the typed value matches to a record’s Form1 Field and automatically fetch the data of Field1 & Field2 to current’s open Form2 record FieldA & FieldB.
This has to be done before the record is saved, on the fly. A proccess like example’s of http://www.scriptcase.net/scriptcase-samples/php-filter-search/capture-linking-in-a-filter/ is not an option for now.
*ideally after I click tab on keyboard for going to next field. Alternatively would do the same if there was a button after the FieldC to ignite the process (check value and fetch the data).