How can i make an automated fields?
When i choose a field from a lookup attached to another table, i want the rest of the fields to be automatically inserted according to the filed that i've selected.
How can i make an automated fields?
When i choose a field from a lookup attached to another table, i want the rest of the fields to be automatically inserted according to the filed that i've selected.
Execute an update query. In the query, Link the key field, update the rest.