Combo Box Selection

[Guest]

I have a combo box to be used for multiple selections throughout one form. I
am able select the different values throughout the form however when I try to
save it I receive the message: "The changes you requested to the table were
not successful because they would create duplicate values in the index,
primary key, or relationship. Change the data in the field or fields that
contain duplicate data, remove the index, or redefine the index to permit
duplicate entries and try again." What am I missing? Any suggestions would be
greatly appreciated!

table tblWord_Info
word_id (autonumber)
word (text)

 

[jahoobob via AccessMonster.com]

The message is one of the most straightforward of Access's error messages and
means what it says. You can't enter a 1 as a primary key field is there is
already a 1 (and you don't want to.) You can't enter "dictionary" in the
word field of one record if there is already another record with the word
field of "dictionary" if it is indexed with No duplicates.

 

[Guest]

Ok, so would I create additional fields to hold the recurring data? Remove
the index to allow for duplicates? I ask because I am stuck at this point.
Thanks!

 

[jahoobob via AccessMonster.com]

You would need to tell more about your data and what you want to do with it.
with what you have presented, you could have two records like this.
word_id word
1 dictionary
2 dictionary
It doesn't make sense to store the same data in two records. The word_id is
not data only an ID as it says.

Ok, so would I create additional fields to hold the recurring data? Remove
the index to allow for duplicates? I ask because I am stuck at this point.
Thanks!

The message is one of the most straightforward of Access's error messages and
means what it says. You can't enter a 1 as a primary key field is there is

[quoted text clipped - 14 lines]

 

[Guest]

The form is a replication of a Microsoft form template. I have a group of
words that I have decided to put in a table to allow the user to select from
this list throughout the form. Ex: The school consists of 4 permanent
(word_id combo box here) and 3 portable (word_id combo box here). I would
like to allow the user the option to select from the same combo box multiple
times throughout the form. I understand what you told me earlier about trying
to save the values in the same field but I do not understand where I would
store them. I am sure I am making this harder than it may be but any help you
may send my way would be appreciated. thanks!

again the structure of the table is as follows:
table tblword_info
word_id (autonumber)
word (text)

Further word_id is also located in the main table as follows:
table tbl main_info
word_id (number)

You would need to tell more about your data and what you want to do with it.
with what you have presented, you could have two records like this.
word_id word
1 dictionary
2 dictionary
It doesn't make sense to store the same data in two records. The word_id is
not data only an ID as it says.

Ok, so would I create additional fields to hold the recurring data? Remove
the index to allow for duplicates? I ask because I am stuck at this point.
Thanks!

The message is one of the most straightforward of Access's error messages and
means what it says. You can't enter a 1 as a primary key field is there is

[quoted text clipped - 14 lines]

word_id (autonumber)
word (text)