Table Design Editing

  • Thread starter Thread starter Tristanne
  • Start date Start date
T

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!!!
 
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?
 
Use forms with combo boxes. You should only need to store a foreign key
value in the bound table.
 
Back
Top