Form Field Results Based on ID Fields

[djossh]

I have a form (FormSalary) which is generated from my "Salary Table" and was linked to another table (Employee Table) since my Employee field in my "Salary" form is linked to "EmployeeID" in my "Employee Table"...

I inserted one field in my form (Name of Employee) This field is not in my "Salary Table" so I just get it from my "Employee Table"...what I want is, everytime i enter the EmployeeID..... I want the "Name of Employee" to be automatically populate based on "EmployeeID"...I read in some forums to create a query first.. but I really don't know how to do it... any help? Thanks

Employee Table Fields
EmployeeID
Name of Employee
Address
Position

Salary Table Fields
EmployeeID
Basic Salary
Allowance

Fieds in my Forms
EmployeeID
Name of Employee (this is from my Employee Table.. I want this to auto populate based on my EmployeeID)
Basic Salary
Allowance

 

[Freshman]

I'm not 100% with you on your structure, would need more info but maybe the DLookup function can work for you.
Read up on it - very powerful indeed and easy to use.