Administrator
  •  Admin
  • Advanced Member Topic Starter
2003-10-30T14:59:00Z
Dear Technical Support,


I have been looking at the potential to use OutlookConnect to import data from our Informix database which contains client contact information; this information is stored in several tables.


Is it possible to connect to more than one table? I would be grateful for any information in this respect.



Many Thanks



Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
  •  Admin
  • Advanced Member Topic Starter
2003-10-30T14:59:00Z
One contact folder can by linked to 1 Table or View.

If you need to use more tables on one Contact Folder, create a VIEW in the database:

Example:(SQL Server syntax)
CREATE VIEW MyView
As
select .... from Customer C, Adres A
where
A.CustomerId=C.CustomerId