How to correctly pull up information using the lookup wizard in Microsoft Access?

Question

Microsoft Access

I am not an IT specialist, I just know that you can automate the process of accounting for travel expenses using Microsoft Access, and now I study this program from books and sometimes from videos on YouTube. Much is clear, but faced with such complexity, please tell me how to solve it.
I have several tables, and some fields in the tables are pulled up by the "substitution wizard" and there was a problem with pulling them up.
Table 1 "Full name of employees" - Fields: "Employee ID" (key) and "Employee full name",
Table 2 "Business trip number" - Fields: "Business ID number" (key), "Employee's full name" (pulled up by the wizard from table1) and "Business trip status" (logical (checkmark): if the checkbox is checked, then the business trip is closed, i.e. all documents / if it is not there, i.e. not all documents have been provided and the business trip has not yet been closed, respectively).
Table 3 "Travel Costs" - Fields "Cost ID" (key), "Cost Date", "Employee Name" (pulled up by the wizard from table 1), "Cost Type" (drop-down list: accommodation, tickets, daily allowance, other), "Travel Number" (pulled up by the wizard from table 2), "Amount".
And when I pull up the "Travel Number" in Table 3 with the substitution wizard, I set the condition so that when substituting this number, the following fields from Table 2 are also visible: "Travel ID number" (we need it), and additionally for informational content: "Travel Status" so that the business trips are open first) and the “name of the employee” (in ascending order, so that you can see the name of the employee for whom the business trip is not closed), this additional information is needed in order to know which business trip number to attribute the incurred costs to.
Several times I removed all connections and re-formed the master of substitutions and all the same. Tell me how you can correctly pull up the information I need in Table 3 in the "Travel Number" field. Thanks in advance.

Answer 1

call the admin or local terpilu - computer specialist

Answer 2

The fact is that in our company there are no Access specialists, there are only 1C specialists, and the admin does not delve into this. That database for automating the business trip process that I have already folded in my head and on a sheet of paper, it is not at all complicated and consists of several tables. Now this account is kept in Excel, but there are many questions for it, because many points are missed there, I know that Access should help me in this matter, but it is not as simple as it seems at first glance, there are some subtleties.