I'm creating a database for a project at work and I'm a little rusty with
Access 2003 so any help would be greatly appreciated. I've started with a
table that I have imported from Excel that contains the employee's clock
number, their name and their supervisor in respective columns. I would like
to create a form that has three boxes. The first is a box that allows the
user to key in (or possibly select) an employee clock number. Once this is
completed I would like for the employee's name and supervisor to
automatically appear underneath the first box. I'm pretty for sure that doing
this has something to do with primary and foreign keys but not 100% sure on
that. After searching through my Access 2003 book and the internet I'm at a
loss. Does anyone have any advice that could help me out? Thanks so much in
advance!