Sorry to keep replying to my own posts, but I have just found a little thing called 'Manage Relational Table' under the Server Behaviours --> Data Assist panel, and I was wondering if this might help me to determine what shipping costs to apply. I'm not sure I understand what Manage Relational Table is actually for!
If I create a shipping table with all the correct shipping values in it including my UK, Europe and rest of the world info, will 'Manage Relational Table' enable me to take a users profile using their unique ID number, and apply the correct shipping? I will obviously need to make users at least register with the website to determine their location.
Would I have the products table as the relational table, the user table as the main, and the shipping table as the options table?
Am I understanding this tool correctly? Is this the table joining tool that I have been asking for this as a feature request and it already exists!!?
Thanks.