Not sure how this is a "table design" question ...

Not sure what you mean by "pull one word from the drop down box"...

Not sure from where you are expecting to "pull up that person's
information"...

Not sure what "information" you're expecting...

Can't offer ideas on "how" unless you provide a bit more specific
description of "what".
--
Jeff Boyce
Microsoft Office/Access MVP


"egoodson" wrote:

I would like to be able to pull one word from the drop down box in a form or
report and it pull up that person's information. Is this possible?