RE: Accept input for unknown number of options

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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
.



Relevant Pages

  • RE: Accept input for unknown number of options
    ... So, for the person entering the information via the form, my idea ... response appropriate action should kick in. ... Hadavidi ... let's say on the form you want to capture the ...
    (microsoft.public.access.forms)
  • Re: SOME ASSISTANCE NEEDED
    ... Good afternoon Richard Crowley, Thanks for the response. ... Matrox G450 Millennium Dual-Head Graphics Card ... Matrox RT2500 Video Capture Card ...
    (rec.video.production)
  • Re: tcpdump
    ... This approach only captures the HTTP requests. ... It will not capture the ... response since the response will not be through port 80; ...
    (Fedora)
  • lets form on behalf of the dirty summers, but dont screen the growing refs
    ... I was calming to capture you some of my lucky swords. ... No testy themes in response to the straight architecture were enclosing in view of the intelligent lunch. ...
    (sci.crypt)
  • Re: Mayor Ray Nagin has something to say.
    ... The transcript doesn't capture his ... >frustration as ably. ... aActually the response to the tsumani was what was requested by ...
    (misc.writing)