View Single Post
  #1  
Old February 10th, 2010, 05:05 PM posted to microsoft.public.access.tablesdbdesign
hntsignif
external usenet poster
 
Posts: 14
Default 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?