06-14-2010 11:24 PM
Hi,
1-I am using ACT2010Demo Database . I wan to know how many table in database. and also wan to know where is store relationship tab value . it values is store into out of contact table. Because I cound not find out it's fields into contact table.
2- How can read relationship tab fields there is show value ---------following
Relationship From
Conatct
Company
Tile
ID/Status
I want to read these fields . how can read it please tell to me.
If relationship field is into tbl_contact_contact table then how can read fields from tbl_contact and tbl_contact_contact table like
I want to read example-(I know this type quesry is not possible into act)
SELECT contact_id,company anme, mailid from tbl_contact,tbl_contact_contact where tbl_contact.contactid = tbl_contact_contact.contactid andrelationship from<>""
please soon reply how can do this and read record agaist of act database.
Saket Dwivedi
SNS System Indore
06-15-2010 03:57 AM
Have a look at these:
http://blog.glcomputing.com.au/2009/04/getting-table-structure-and-links-from.html
http://blog.glcomputing.com.au/2009/07/connecting-to-act-by-sage-data.html