If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help! Designing database
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? |
#2
|
|||
|
|||
Please help! Designing database
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? |
#3
|
|||
|
|||
Please help! Designing database
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? |
Thread Tools | |
Display Modes | |
|
|