GeniusConnect support forum
GeniusConnect support forum
Home | Profile | Register | Active Topics | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Database
 Informix
 Folder and multiple tables
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic  Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Admin

Czech Republic
1677 Posts

Posted - 30 Oct 2003 :  14:59:03  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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



Admin

Czech Republic
1677 Posts

Posted - 30 Oct 2003 :  14:59:32  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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

Kind Regards,


Go to Top of Page
   Topic  Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
GeniusConnect support forum © Copyright (C) 2003 - 2019, GeniusConnect, All Rights Reserved. Go To Top Of Page
Snitz Forums 2000