This is more SQL than VB , but here goes...
If I have shop branches with different
databases and I want to collate a report on sales at all branches, AND
the user only gets a VB interface to
do this, what is best method of
doing it ? Do I run stored procedure
that extracts local branch data then
gather that together into a central table for Crystal Reports. How
do I transfer the data - use some custom
interface to harness SQL data transfer
or just pass data as a byte stream
eg property bags ?