That's true. Anyway, it was suggested by my manager. The application doesn't have ability of changing lookups tables, they allways have to Download new tables from us. We maintain Lender List and Nespapers list here in the office. They should always have a recent version of these tables because Lender table is updated weekly...

I actually invision this application as WEB-based and I already mentioned this idea to my manager briefly, but we first have to concentrate on putting current Desktop version into production. I also have lots of other more pressing projects, though relatively small...

>Another problem that you might run into with time is that Lookup tables are not always as stable as you'd like. Do you not give the user any way to add new codes if they're needed? I find that very few lookup tables will never have new codes added. A good example is our Province table. For years it was stable - 10 provinces and 2 Territories. Then we got Nunavut. True, a thing like that won't happen a lot, but I'd hate to have to send a new executable every time the user needs to update their lookup codes. Besides, I'm sure our users would eventually become very annoyed by having to call tech support just to add a new code.
>
>Alan
>
>>If it's get corrupted, I would have to send them new executable, I guess... Lookups tables are stable, e.g. Usage Groups or Building Style codes or Roof Materials. The only tables, which update frequently, are Lender list and Newspapers...
>>
>>It was my manager idea to include them into the project... I'm just wondering our possible problems. One I already found yesterday: if table is included in the project, it's used instead of the one, I specified. Weird, I specified the full address...
>>
>>>Nadya, I'm curious: If it is included in the project, how do you repair it if it gets corrupted? Or does it never get corrupted if it is included? Also, you never need to add to the lookup tables?
>>>
>>>
>>>>Do you mean, that these tables are always free tables? It's not my case, I already have Lookups database with lots of tables...
>>>>
>>>>Anyway, it looks like it works, though I didn't yet run an exaustive test. The only problem I found so far that if I have two tables (one free and not included, another part of a Database and included), the form always tries to open the Database table despite the full path, I put...
>>>>
>>>>>>Hi everybody,
>>>>>>
>>>>>>I have Lookups database. Most of the tables are static and only few can be updated on a regular basis. I'd like to include all the tables into the project and exclude only the tables, which could be updated.
>>>>>>
>>>>>>I already tried that and the problem, I got, was: I have a combobox on a form with RowSourceType = 6 (fields). I receive an error message trying to instantiate the form: Phrase "field" is not found.
>>>>>>
>>>>>>So, my question is: can I use partial inclusion of tables from the Database into the project? What kind of problems may I experience with this approach and what should I check?
>>>>>>
>>>>>>VFP6 SP4 and native VFP tables/databases.
>>>>>>
>>>>>>Thanks a lot in advance.
>>>>>Nadia
>>>>>Usually I have few databases in the project
>>>>>The frosen (included) tables are free from databases
>>>>>It works already in 6 different projects well enough
>>>>>Frosen tables are also used in interface components
>>>>>Vladimir