I am creating an expense report app and have the following tables: employee, entry form, travel expenses, mileage expenses, other expenses, documents. When an employee needs to create a new expense report, I want them to be able to enter in their employee #, then hit enter/save so their address/manager information will automatically pop up. From there, they can start adding expenses for reimbursement.
I have the 'add new expense report' form created in the Entry Form table, but can't figure out how to get the 'enter employee#' field to cross reference back to the employee# field in the Employee table so it pulls up the respective information.I really don't want to use a dropdown lookup field as it would be quite long with all the employees we have.
You will need to ensure that the key field if your employees table is the employee number.
On the expense record, make a field called [Enter Employee #] which is just a data entry field of the same type ( probably numeric) as the employee number.
On the existing relationship which currently has that drop down list, change the Field which might be called [Related Employee] to be. Formula field equal to the [Enter Employee#].
That should do what you want.