Hello,
I have two tables with information on employees, each employee number only comes up once per table, I would like to be able, in a form, to be able to pull up all the info from both tables when I type in an employee number. Is this possible.
ex.
Table 1: empl:9999 win98
Table 2: empl:9999 Office Xp
I want to be able to pull up a form that has:
Form: empl:9999 win98 Office XP
I have two tables with information on employees, each employee number only comes up once per table, I would like to be able, in a form, to be able to pull up all the info from both tables when I type in an employee number. Is this possible.
ex.
Table 1: empl:9999 win98
Table 2: empl:9999 Office Xp
I want to be able to pull up a form that has:
Form: empl:9999 win98 Office XP