Where on earth is that setting???!

hi Gass,

There is no fields avaialble in HQ but it will bring the data from store, actually all these fields data are store specific and it can full fill the requirments of stores where may one sub description is different in other stores.

Akber

"Philip Gass" wrote:

Thanks for the input on this one...

I dont know how it happened, but when i came into work this morning after setting some worksheets to go last night, the custom caption in the HQ database had changed to match that of the SO one. So i can only assume the data has travelled up, eitehr that or something else i am unaware of has changed it. (i have some addins which may have affected this)

Thanks for your help

Philip

Philip - I was able to do a quick remote connect to an HQ machine and there's a customcaption table there as well. At the store ops, make your changes in captions if needed then run query as follows

select * from customcaption

this will show you how your captions are defined - note the HQID

then at hq - connect to your hq db with HQ Administrator run the same select query to see how its currently set up

then you can update the HQ table (just the caption) column run.... update customcaption set caption = ' xxx' where id = y

in the above query xxx = the text you want to assign to the caption (use single quotes), and y = the HQID number assigned at store ops

h> Hi Philip - I ran into this same problem a few weeks ago - the custom