How do I create new records in a form?

[Guest]

I am creating a database, where there is going to be a couple of fields that
require a drop down list that allows a couple selections to be made when
records are entered. I entered a majority of the data into tables. I was
originally going to have all data entered through a master table, but found
out the look up boxes only allow one text selection. I was informed that a
list box in “Forms†is the only way multiple selections can be made. So I
set up a list box allowing for multiple selections. The problem I am having
now is entering records into a “Form†and saving them. For instance right
now, I only have one field entered:

Plants [List Box with ten plants] set to Multi Select
I can select the multiple text in the “Form View†but I cannot save or
create a new record.
In the same Form under datasheet view I can create new records and save but
I cannot multi select items.

Am I even going about this the right way? Please help.

 

[Guest]

I think you are misunderstanding what a multiple select list box does. The
field in your table can hold only one value, so you would not be able to
include mutiple plants in the same record. If you need multiple plants
associated with the table you will have to create a child table that holds
all the plants associated with the record.

 

[John Vinson]

I am creating a database, where there is going to be a couple of fields that
require a drop down list that allows a couple selections to be made when
records are entered. I entered a majority of the data into tables. I was
originally going to have all data entered through a master table, but found
out the look up boxes only allow one text selection. I was informed that a
list box in “Forms” is the only way multiple selections can be made. So I
set up a list box allowing for multiple selections. The problem I am having
now is entering records into a “Form” and saving them. For instance right
now, I only have one field entered:

Plants [List Box with ten plants] set to Multi Select
I can select the multiple text in the “Form View” but I cannot save or
create a new record.
In the same Form under datasheet view I can create new records and save but
I cannot multi select items.

Am I even going about this the right way? Please help.

No, you aren't.

It's a very common mistake you're making: jumping to Forms first, and
then figuring out your tables. That's like building the windows and
siding of a house, and then deciding where to pour the foundations!

If one record can be related to multiple plants, you need TWO TABLES
in a one to many relationship. You cannot store multiple values in one
field; that's not how relational databases work!

What is in your table? What information should be in these many-valued
fields?

John W. Vinson[MVP]