View Single Post
  #47  
Old January 28th, 2010, 02:13 AM posted to microsoft.public.access.tablesdbdesign
Armen Stein[_2_]
external usenet poster
 
Posts: 157
Default Prospective Client Tracking Database

On 27 Jan 2010 02:41:33 GMT, "David W. Fenton"
wrote:

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.


Good point. We've done the unique values approach too, but you can
run into performance problems on large recordsets.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com