As with the Basic Procedures, make a back-up copy of the orders database (shop.mdb) before following this procedure. You will be adding and removing fields in the database. As you follow this procedure, tailor the changes to meet the requirements of your shopping cart.

This procedure builds on the Basic procedure discussed earlier. This more advanced procedure allows you to ship to different destination "zones," instead of the single "US" shipping location defined in the previous section.

The shipping destination is set to "US" by default. You can select multiple regions within the United States and can add global regions if you sell internationally.

The shipping destination is set at two locations, the "Country" field of the details1.asp page and the "Country" table of the orders database (shop.mdb).

SalesCart does not do shipping on a Zip Code basis due to the thousands of zip codes that are available. To do this, you would have to define a database relationship for each zip code, an intense task to say the least. If you must ship by zip code, we recommend shipping by regions, or purchasing the UPS Autocalculator plug-in.

1. From the cgi-bin folder in FrontPage, double-click on details1.asp.

2. In Normal mode, right-click the form pull-down box under Country, then select Form Field Properties.

3. By default, the Country field allows you to define shipping by "Country." The default values are "US," and a list of other countries. This is the "destination" portion of the relational shipping database. If you determine that you want to have more specific shipping areas in the US rather than just "US' you can add those choices here, and also in the shipping portion of the orders database.

4. For our example, we will leave the default countries in place, but separate the US shipping area into 4 shipping zones, "Western US," "Eastern US," "Alaska," and "Hawaii."

5. Scroll down the choices of the drop down menu and Remove the "United States" entry.

6. Add the following entries to the drop down form field options; Choice "Western US" Specify Value = "wus," Choice "Eastern US" Specify Value = "eus," Choice "Alaska" Specify Value= "AK," Choice "Hawaii" Specify Value = "HI" . (You cannot assign more than 3 characters to the "Specify Value" field.) See example below:

7. Close the Form Properties dialog box.

8. In HTML mode, modify the text above the box, changing "Country" to "US Shipping Region / Country."

9. Save and close the page.

1. Now that the selections on the details page have been added for the customer to see and use, open the orders database (shop.mdb), in Access, for modification.

2. When the database opens, minimize but don't close the automatic Switchboard.

3. Open the database view and select the Tables view, shown below. In FrontPage version 2002, Tables will be located under Objects.

4. Open the Country table. The Country table has two fields, "Abr" and "Country." SalesCart uses the value property of the drop-down field on the details1.asp page to query to the "Abr" field of the "Country" table of the database.

5. Add the following region abbreviations from the details1.asp page. Scroll to the bottom of the list and add the following entries:

6. Save the database.

You have now defined new shipping regions. You can use what you have learned here to add and remove shipping destinations as you require.

You can now select from various shipping regions when you go to "Define Shipping Charges," in the database. When you set the shipping relationships, you will have a drop down menu in the destination field that will list the new shipping regions you just defined.