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