I have two tables like
Staff Table
............
Staff ID
Staff Name
Age
...and more
Staff Salary Table
..................
Staff ID
Staff Name
basic Salary
...and more
Now I have created the Staff Salary form in which I got the staff ID from the staff table using the lookup wizard query in the Staff ID field of the Staff Salary Table
SELECT [Staff Table].[Staff ID] FROM [Staff Table];
but I need one more
When The staff ID was selected from the drop down list, I need the relevant staff name (from the Staff table) also be displayed in the staff salary from .
Can you please let me know how to do this..