joining database

[jeffp60]

i have 2 databases 1) employees 2) jobs.
emplyee has A)number B)names,job has a) nunmber and b) job description and C) shift.
i need to be able to search for any one of the fields. i need to find employee by number and enter new job number when they change jobs. is there a way to just enter the job number and associate the new job to the employee

 

[suesloan]

If you know the employee number, you could just type it into the employee number field in the job record on a form view of job records. Or you could set up a drop-down list of employee numbers with the "description" set to show the employee's name to make it easy to select the right one.

Sue Sloan