You said" If you want to update your orders to add in a checkbox for shipped you would first need to ensure that you had this column in your orders table, then you can add in a checkbox form element to the udpate page and edit the update server behavior to use this new checkbox for the shipped column."
Of course - I know how to add the column to my table. But can you please be very specific as to how I would use Data Assist to add this check box to my table and how I would use Data Assist to change variables in my site? I would like the site Admin to be changed via Data Assist. Specifically how do I sync up this PowerStore 3 with Data Assist? I know how to do a brand new site with Data Assist - but not how to work with an existing one.
Also - Is there a way that I could make the ProductSKU the ProductID? It doesn't make sense to me that there would need to be two numbers here - - we reference everything by Item Number. (And BTW in retail terms the SKU and the Item # are also two different things. A SKU is usually a long number that is on a bar-code and is used with most retail POS systems. An Item # is what is usually the shortened version of the SKU and is usually what is used by most manufacturers to reference all of their products in their catalogs.) I would like what you are calling ProductSKU to be the ProductID aka Item # and it not be automatically generated - but be what I am am entering in that field and for that to be the table's Key.