Has anyone ever done any AJAX/Javascript coding that will allow the Add form to autocomplete the fields based on the records of another table?
For instance:
Say a record is pre-filled from another table, in an early data entry manner with minor details. Then, when the record is needed in another table to be linked to a certain "event", the user can Add a new record for the new table, which when typing a name in the box, the corresponding record will be populated in the editboxes for that add page. At which point, the records can be linked with the detailed data and the master record.
I know this is possible with AJAX, because when you type in the search field it autopopulates the data based on a query.