Adding additional field to RMS table

For reasons which are too annoying to go into here, I would like to add a field (nvarchar 50) to the Item table in RMS Headquarters and RMS Store Operations. I have avoided adding additional fields thus far, but the SubDescription field is too short for my purposes.

Other than the fact that I will lose that field if I migrate to a later version of RMS, is there any problem with this? For that matter, what if I need to add additional indexes, tables, etc to the RMS database?

Bill Yater The Worth Collection snipped-for-privacy@worthltd.com

Reply to
Bill Yater
Loading thread data ...

Well, adding tables is always safe. Adding indexes is usually safe, unless you get carried away - too many indexes can be just as bad as not enough. I wouldn't recommend adding columns to a table, for the reason you cited - you may lose it in a future update. Instead, I would add a table and link it to Item.ID.

Extended Description and Notes are both text fields if they aren't yet in use...

Anytime you make changes to the database make sure you take a backup and TEST thoroughly before applying the changes to your production database.

Reply to
Glenn Adams [MVP - Retail Mgmt]

You can to use the table 'TableSync'. HQ sync all tables inserted into TableSync after the worksheet data upload..

You must be create the same table (see doc. about tablesync) into HQ and into the Store..

bye Antonio

Reply to
Antonio Mazzeo

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.