The client doesnt want to display both currencies prefering to display either sterling or euro depending on the login details, sterling for UK customers and euro for all non-UK customers.
The transaction through to gateway would then be completed in sterling so only the display on results and detail pages would need to be either sterling or euro.
I'm OK with the extra database column and the insert/update pages but need help with the following from your earlier post.
"you would need to modify the login to store the users country in a session variable"
"on the product pages, you would need to create an if statement to show the proper column based on the session value"
I enclose the login and product pages.