Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Viewing Company Data From A iMIS Database

Hi,

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.

DJ

Tags:
Former Member
Former Member replied

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.

DJ

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question