View Single Post
  #45  
Old January 27th, 2010, 03:41 AM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Prospective Client Tracking Database

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/