Now going round in circles. The dilemma is I need to satisfy four things from the checkout page to the confirm page for countries as follows:
1. Checkout automatically fills in countries field (dynamic menu) after login
2. Checkout shows country label (after setting dynamic menu values/labels/values equal from recordset)
3. Confirm page correctly calculates tax and shipping using countries abbreviation (eg GB)
4. Confirm page shows country abbreviation or title in address
I've tried just about every setting in the countries dynamic menu setting and can get 3 of the above working but never 4
Ideas:
Add an abbreviation field to the countries table and try again
OR
Add a recordset to the confirm page and set the formulas for tax and shipping to use IDs instead of abbreviations (EG US). Note: Can't use DW to add recordset as get a javascript error so will need to hand code it in.
OR
There's a better session variable satisfy all the 1-4 above which needs hand coding
What's best