>> > I have 5 machine network with an NT4 file server.
>> > To reduce the network traffic, I would like to have an always
>up-to-date
>> > local list from the product table. This list would contain only the
>> product
>> > names. (Number of these can be greater than 10000)
>>
>> You want a local list on each of the 5 machines? I would consider this
>> carefully, taking into consideration how much information each machine
>> will be retrieving. You should, in fact, stress-test the setup to
>> ensure that it is saving a significant amount of time.
>>
>> IMHO, it'll be more work for you in the long run.
>>
>> > The problem is (for me), keeping the local list always updated.
>
>well you can use off-line views
>when you want ot update thier info just take them on-line again , requery
>and then make them off-line
>
>Arnon
Sorry to just jump in and change the subject. This is to Arnon. I was wondering since you mentioned the use of off-line views, can you briefly explain to me how you are using this feature? I'm still using 3.0 but if 5.0's off-line view can help me in my situation I wouldn't hesitate upgrading. I need to keep copies of VFP database syncrinized between main office and 3 remote offices. Can or Is off-line view apprpriate for this kind of use?
John
It's "my" world. You're just living in it.