Hi Asif..

>>>Can you describe your data set and are you using local or remote views to access the data? Using a VIEW off on one table.. I did this to learn
how to use VIEWS.


>>
>>I have one database with 5 tables. I use these tables as views. these database
>>lives on a network drive running novell...rob
>

>Can you tell me a little more about your views? - I only have one VIEW.
>
>Does a single view gather info from all five tables? no - view gathers information from one table.
>
>On average what is the size (in records) of a view and what is the record length in bytes? it is small, about 1000 records, but growing...the record
length in bytes is about 615.
>
>Are the tables related via surrogate keys that are integer or compressed character based? only one main table used, but I have tables for my combo box
values.... thanks rob