Prev: Adding records with referential integrity
Next: No Duplicates for Full Name
From: egoodson on 29 Apr 2010 10:02
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?


From: Jeff Boyce on 29 Apr 2010 11:11
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?
>
>
From: Dorian on 29 Apr 2010 17:36
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?
>
>
 | 
Pages: 1
Prev: Adding records with referential integrity
Next: No Duplicates for Full Name