May I start by saying what a great add-on this product is!
I'm evaluating it for my company (Outlook 2002 and SQL server) and have a small issue.
I suspect that it is not possible to do what I want, but thought it worth posting the query here for your thoughts and views.
Our users create tasks using custom forms and user-defined fields. All are visible in GeniusConnect. However, two of the fields are populated with drop-down lists. When using the Save to Database button, the fields both revert to the default setting, which is copied to the database and retained in the task.
[e.g. The fields are depot selections, default "Depot?" with a drop-down list of depots. GeniusConnect resets the selection to "Depot?" and copies this value to the SQL DB]
Have I configured the transformation incorrectly or are drop-down lists unsupported?
All views welcome.
lex