If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup needs to fill two fields
OK this may be easy but I am stumped.
I have a table "Employees" it has two columns: Employee and GroupTitle I have a second table that tracks points per job called "PointTrack" and I have used a lookup column to pull in the Employee Name. The lookup column shows a drop down with the employee and grouptitle fields because some employees are in more than one group and this allows them to choose the correct group. What I need is to have both the Employee and group title visible in the form based on the PointTrack table. Right now, I can have them choose in the dropdown seeing both fields, but only the employee name shows up once the choice is made. How can I have both fields show in the box once the choice has been made in the dropdown? |
Thread Tools | |
Display Modes | |
|
|