>hi all,
>i am currently developing a client server application from an old system, but have run into a design problem. the software has a lot of lists in combo boxes for the user to select from and it seems that on start up, dragging all this info across each time the form loads will create to much of an overhead.
>i know about maintaining the lists on each client machine, but doesn't this get messy when people add to the lists??
>what is the best way to have all these lists and maintain integrity to the database?
>Jordan
Are the lists updated frequently ?
If not, move the data locally. Create a table on your server where you would have the date of the last update for each list table. When you start you program you can check if the local data is up to date.