I have a join to a SQL table on a seperate server, and the way I preserved the join in all my web applications was to create a ODBC data source connection to the SQL table. Once the connections were created I have no problem creating my joins and pushing the data out to the web
Aaron N
Town of Vernon, CT