• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1039
  • Last Modified:

Act! Table Relationship contacts and addresses

I understand that Act! has some encrypted functions that I can't see. Does that have anything to do with why I can't seem to figure out the relationship between tbl_contact and tbl_address? Am I missing something? Is there a way around this? I write views in SQL and then use them for reporting in MSAccess. I can't add an address to a contact because there are multiple addresses for each contact_id in the tbl_address table. What am I missing? Thanks!
0
socallilly
Asked:
socallilly
1 Solution
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
No, that's not it.

Have a look at these:

http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html

http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html

There are two ways to connect OLEDB (which already has the views) and ODBC - the best option depends on which version of ACT! you have and the types of info you're trying to get
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now