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?

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?
>
>

If you mean to pick say a persons id or name from a list and then display the
information related to that person, you can do it via a subform. You have
your main table related to another table via a foreign key and then the
subform automatically displays matching rows in the related table. There is a
lot of information about subforms in Access Help.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"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?
>
>