completely remove HQ store?

Hey there Bob ;)

I'll give you both the long and the short versions;

Short: "Not really."

Long: This has to do with a few things, but namely the primary AutoID of the Store table in HQ. Like any ID field, it can not have duplicates, nor can you delete it and make a "new" 2, as the ID counter can only hit the number 2 once while the table constraint exists (this is NOT where you go find out how to remove the constraint, that is a BAD BAD BAD IDEA).

Remember that RMS is a SQL client, albeit a fancy one, and it's bound to the laws and constraints of SQL. If you want to "replace" store "number 2", the only real option is to use the "existing/old" number 2 and wipe out all the associated information from the previous store and fill-in the store info for that number with the "new" information. I'd advise against this for only one specific reason; that you're not going to have an easy time wiping all the information unless you do it one table a time, as there's LOADS of stuff in the HQ database that you can't see from the HQ front-end. In all honesty, it'd be easier to just deal with having the new location as "store 4".

YidMo

"Tech Bob" wrote:

Hello YidMo,

That makes sense due to the fact that using the same store ID which I take is the AutoID was the reason why we had users, and other internal information that the AutoID was the same.

So I take it we should just use 4 being that there are still stores 1, and 3 are up and running.

Thank you,