Armen Stein wrote in
:
- we create tblCity
- we create relationships from any table with an address to
tblCity using CityName, without enforcing referential integrity.
- on our forms, the City combobox helps users remember the
spelling of the city and type it in faster.
- the City combobox traps for NotInList and silently adds a new
City on the fly.
- we build a simple admin screen to allow the user to delete
incorrect cities. They should also find and correct those cities
in the address tables.
I never bother with that. I just base the combo box on the unique
values for the data field it's bound to. This does require a hidden
field for saving the data before requerying the combo box, but it's
so much easier that mucking around with maintaining a lookup table.
--
David W. Fenton
http://www.dfenton.com/
usenet at dfenton dot com
http://www.dfenton.com/DFA/