1. GeniusConnect support
  2. Database
  3. SQL
  4. Mapping 2 or more fields from the DB to 1 Outlook
Nzer_de
2006-06-14T18:52:00Z
Hi There,
I just tried out the demo version and it works quite nice. There is one more question. Is ist possible to link 2 or more fields of the Database to 1 Outlook field f.i. "The body" field. Something like Body=DB_Field1 & DB_Field2
Thx for your help
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Nzer_de
2006-06-14T18:53:00Z
...i forgot. It should only work one way i.e. just for updating the outlook contacts
Administrator
2006-06-14T19:05:00Z
Hello,

you can use a database VIEW (query in MS Access) to join 2 columns and present it as 1 column to GeniusConnect.
Nzer_de
2006-06-14T19:20:00Z
ok. but where do i have to do that VIEW. Can I manage it from GeniusConnect (...with SQL commands?) or in the DB ? I cannot change the db because it's a sold product from SAGE...
Administrator
2006-06-14T19:25:00Z
You must add the VIEW in the DB, a VIEW is not changing anything in the database, it is only a different VIEW on real tables/data.
I think SAGE is working with MS SQL Server? If you have a login, just create the VIEW.
Administrator
2006-06-14T19:29:00Z
You can even add the VIEW in a different (NOT Sage) database, and join the Sage Table in this VIEW. So you will not change anything in the SAGE database.
Nzer_de
2006-06-14T19:48:00Z
this version isn't sql server yet but i was able to open it with access...works fine....but it still would be nice to do that in GeniusConnec too. Thx a lot
 Atom Feed Rss Feed
Similar Topics
  1. GeniusConnect support
  2. Database
  3. SQL
  4. Mapping 2 or more fields from the DB to 1 Outlook