Viewing Company Data From A iMIS Database
I'm using crystal 9 & iMIS 20.1.
In our database we have setup a Key Contact relationship between a person & a company. A person can be the Key Contact at a company other than the one that's listed on their record in which they are linked by a CO_ID (company ID). The only link to the 2nd company is thru the relationship id.
I'm trying to get the report to return both company names that the person has a relationship with of Key Contact. I've linked ID from the Name table to the Target_ID in the Relationship Table. When I run the crystal it's returning both Company ID's (which it should) but only the name of the company that the person is linked to by the CO_ID.
How do I get both company names to show?
Any help would be greatly appreciated.
I wanted to update this post since I was able to figure out the answer.
I added a second instance of the NAME table in order to get what I needed.
Thanks for your suggestions.