Table Design Editing

[Tristanne]

OK, I have developed a table with multiple drop downs,
when I go back and look at the table the drop down
information is there, but once you make a selection a
number populates the table. When I go back to try and
change the design so that the word yes or whatever the
selection may be is what is displayed. I get an error
that syas I have to remove the relationships that I have
already derived in order to fix this. I don't mind doing
that, but does that mean I basically have to go and
completely re-build the database and the two forms that i
have built that are related to this main database? I am
really not interested in completely re-building a
database and forms I have spent a week and a half working
on. HELP!!!

 

[Duane Hookom]

Consider reading http://www.mvps.org/access/lookupfields.htm. If you have
other questions, come on back.

 

[Guest]

OK, if I shouldn't use drop downs, then how do you
provide a list of data for people to choose from that
will auto populate the table and preserve the integrity
of the data?

 

[Duane Hookom]

Use forms with combo boxes. You should only need to store a foreign key
value in the bound table.