Re: Difficulty with List Selection and New Records

Great! Thank you for the information! I will definately try what you've
recommended! If I have any other questions, I will let you know!

Thanks again!,
Whitney


"Douglas J. Steele" wrote:

What you've got is a classic many-to-many relationship. You've obviously got
Patents and you've got Inventors, but one Patent can be assigned to multiple
Inventors, and one Inventor can hold multiple Patents, so the correct way to
handle it is to create a third table to resolve the intersection of the
other two tables.

What you typically do to maintain the information is use a form with a
subform on it.

Take a look at the Northwind database that came with your version of Access.
You've got the same many-to-many relationship between Products and Orders
(one product can appear on multiple orders, one order can contain multiple
products), so the Order Details table was introduced to resolve the
many-to-many. The Orders form includes the Orders Subform form as a subform
to allow you to maintain the data.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Whitney" <Whitney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20456DB7-DC4F-4C38-81F7-7FF99F3905CD@xxxxxxxxxxxxxxxx
This is what I'm trying to do:

I have a list of inventors who have created a specific patent. I need to
select each name that is associated with a patent. Then I will need to be
able to search a single field/list/whatever it's called for their name.
Is
this possible?

If not, will it be possible to create an object that you enter a name
into,
and then another object "pop up" for another name entry?

Thank you so much for your help!


"Douglas J. Steele" wrote:

Sorry, I'm having problems understanding what you're doing.

What's the list? Why are you selecting multiple names from it? Are you
hoping that if you select multiple names, you'll be able to store
multiple
names in the record? You can't: Access doesn't work that way.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Whitney" <Whitney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:497E0B33-99A7-493C-862C-1D433E5B2A09@xxxxxxxxxxxxxxxx
Thank you for the information. What you're saying makes sense.

I'm needing to select several different names from the list. Each
record
will have several names associated with it. Not all records will have
the
same combination of names. But in the end, I need to be able to search
the
fields for the different names. Does this make sense?

Whitney

"Douglas J. Steele" wrote:

That's the way multi-select list boxes work on continuous forms.

You cannot bind a multi-select list box to a field in the recordset.
This
is
because a field can only hold a single value, whereas a multi-select
list
box represents multiple values. What that means is that while it may
look
as
though you have multiple list boxes on the form, in actual fact you
have
a
single list box, repeated multiple times, so that, as you're seeing,
changing one of the list boxes changes them all (since they're all the
same
list box)

What are you hoping to do with the list box?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Whitney" <Whitney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6FAE947D-F5D5-4CD1-BCD9-6205BD577E65@xxxxxxxxxxxxxxxx
I'm creating a database for work, and I have NO EXPERIENCE with
Access,
other
than the file I'm creating now. So please keep this in mind when
answering
my simple question.

I need to create a list that allows multiple selections. I have
successfully created lists that allow multiple selections. However,
when
I
create a new record in Form View, the same selections from the
previous
record are maintained. When you change one selection, it changes
them
throughout the entire database. Also, when the database is saved
and
closed,
it does not keep the selections.

Help!

Thanks,
Whitney C.









.

Relevant Pages

  • Re: lcdui - List vs ChoiceGroup (midp1.0)
    ... selections implies an immediate response. ... application work like my description of menu, or were your lists EXCLUSIVE or MULTIPLE and acted on by a Command? ... are there any disadvantages to a single ChoiceGroup on a form? ...
    (comp.lang.java.programmer)
  • Re: Difficulty with List Selection and New Records
    ... Why are you selecting multiple names from it? ... Doug Steele, Microsoft Access MVP ... I need to create a list that allows multiple selections. ... successfully created lists that allow multiple selections. ...
    (microsoft.public.access.gettingstarted)
  • Re: Difficulty with List Selection and New Records
    ... Why are you selecting multiple names from it? ... Doug Steele, Microsoft Access MVP ... I need to create a list that allows multiple selections. ... successfully created lists that allow multiple selections. ...
    (microsoft.public.access.gettingstarted)
  • Re: Difficulty with List Selection and New Records
    ... That's the way multi-select list boxes work on continuous forms. ... box represents multiple values. ... I need to create a list that allows multiple selections. ... successfully created lists that allow multiple selections. ...
    (microsoft.public.access.gettingstarted)
  • [Full-Disclosure] Re: Full-Disclosure digest, Vol 1 #1933 - 20 msgs
    ... read from multiple peoples articles that it isn't this kind of bug. ... > that about how bad Windows sucks from people who don't know enough about how ... I don't do it out in the public lists like ... >>because you have a bug up your bum about it and work to prove that stance. ...
    (Full-Disclosure)