>That sounds like a good idea, the view bit.
>
>If I was to create a view in the designer which gathered as much info as possible in the Select, how would I then increase the fields on the view to accommodate the information that will come from the program that runs for the other half of the info?
>
>Thanks
>Kev

I just include those fields in the base table to begin with. That way you don't have to worry about adding anything later.