Lookup Wizard at the time of designing table

[jina]

I have following tables (for test purpose)
Employee Table:
Employee ID (Primary Key)
Employee Name


Salary
Remarks
Salary Table:
Document ID (Primary Key)
Employee ID
YYMM
Salary
I am trying out the option of Lookup wizard at the time of
designing the table structure. What I need is, when user want to
enter the data in Salary table, system should provide a help in
Employee ID table with the following column
Employee ID and Employee Name
User should be able to search by Employee Name and Employee ID
should get saved in the Salary table. The wizard allows us to do
this (displays two fields), allows the user to select but it always
saves the first column. In the wizard, even though I select
Employee ID to be saved, if I use Employee Name as the search
field, Employee Name is getting saved instead of Employee ID.
Please help me.

[Bob Fitz]

Sound like you need to use a main form with subform kind of arrangement. Users should never have direct access to tables. They should use forms to add/edit data.