RE: Accept input for unknown number of options
- From: Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 12:35:02 -0700
You need a child table to the table that has the people in it. Then you can
have as many addresses as you want for that person. It will need to be
linked to the person table with some kind of identifier.
You can then create a sub form for the form you use for persons to enter and
view their various addresses.
I don't know what level of knowledge in Access you have, so I am not sure
how to proceed with the response.
"Hadavidi" wrote:
> Can someone suggest a way to capture more than one response to a given data
> element. For instance, let's say on the form you want to capture the
> addresses for a given person. Due to various reasons, in my situation, a
> person might have any number of personal, business and leisure addresses.
> Without setting up any artificial constraints is there a way to carture this
> information. If one were to use scripting any hints of how to go about it
> will be deeply appreciated.
>
> Thx
> Hadavidi
.
- Follow-Ups:
- RE: Accept input for unknown number of options
- From: Hadavidi
- RE: Accept input for unknown number of options
- References:
- Accept input for unknown number of options
- From: Hadavidi
- Accept input for unknown number of options
- Prev by Date: Accept input for unknown number of options
- Next by Date: Re: Accept input for unknown number of options
- Previous by thread: Accept input for unknown number of options
- Next by thread: RE: Accept input for unknown number of options
- Index(es):
Relevant Pages
|