thanks for the reply. The problem is it's a custom table at HQ that we want to sync up with a version at each store. Hence the problem in trying to reference the HQ database in the sql statement
thanks T.
"c> DO NOT USE worksheet 51 to copy data from hq to stores....use the appropriate
When worksheets process, they're not actually linked across the two (store and HQ) databases, info is passed through temp tables, so the answer is: no. On the other hand, there's other options like back-end SQL server linking that could easily accomplish what you're looking to do from what I gather. If you were to set-up the HQ database as a linked db at each location with the same name, then you could use a 51 to pass a query down and run on each location's db which would grab from HQ. This would NOT work if there's firewalls or other barriers that would stand in the way of a SQL linked server connection. If you'd like more information/help, please feel free to contact me ;)
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.