Hi Nabil,

>
>Do you store the lookup tables on every client machine?

Yes.

>How do you regularly update these tables on the client machine?

After the user logs on, I display a download of lookup tables screen. The screen allows the user to download all or some of the lookup tables. The user can bypass the download entirely if his lookup tables are up-to-date.

If you want my code to update local lookup from MSSQL Server, let me know.

Paul de Niverville