Can a store be deleted. We are trying to add a new store to HQ and there was at one time three stores. The second store went out of business and was deleted in HQ. Now when we went to add a store to HQ we chose the store ID to be 2. After doing all that and then placing it on a new POS terminal it has all of the second stores information on it. So my question is.... when you delete a store does it really delete it or does the information stay somwhere in HQ?
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".
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.
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.