How to fill the columns in the form of MS Access with default values, taking them from the table?

Question

SQL

Is it possible when creating a new record in the form and the primary selection (already in the new record) of the option of the "Index" value, according to this index, fill in the value of the "Employee" and "Options" columns for the last date based on the data of the "Archive" table.
That is, the idea is that the operator, creating a new record and choosing an index (roughly speaking, a key), will receive in the new record the fields already filled in with the last known data and, if desired, will be able to change them and already write them to the table ...
Here is an example of a database:
Download

Answer 1

Of course you can. You catch the After_update event of the desired field (Index), then you execute a query to the table, scoop data from it and substitute it in the required fields.