I want to be able to add automaticly data to several fields when choosing from the lookup field
I have an application for expenses and Employees need to add records to this table.
I want the employee to select their name from the lookup field and automaticly fill the corresponding ID and Company fields that correspond to him
How can this be done?