Hi,

I want to create a report that links a secondary contact to specific details.

I can create a report that groups by 2nd contact and inculdes all details of a specific type, but what I wanted to try was link some details (of a defined type) to 2nd contact by maybe using Reference in 2nd Contact value = Reference in the Detail.

So if I have a detail type of 'SAMPLE' and a reference value of 'ABC', if I had a 2nd contact of  'DV' with it's Reference value of 'ABC', and also had other details of type 'SAMPLE' but without the reference value of 'ABC' then the report would only show one detail entry for that 2nd contact.

Is this possible ?

Thanks

Hi,

You should be able to do something like this by modifying the join to include that additional condition you describe. So, if the join is something like:

TABLE1 inner join TABLE2 on TABLE1.ID = TABLE2.ID

You could modify it to be something like:

TABLE1 inner join TABLE2 on TABLE1.ID = TABLE2.ID and TABLE1.REF = TABLE2.REF

Please keep in mind that Goldmine sometimes has the tendency to stuff extra information in fields that it doesn't display in the GoldMine client. For example, I believe it puts a Contact name in the reference field of a history record, even though you can't see it in Goldmine itself. You may need to lookup the fields you are trying to join on with a tool like SQL server management studio, to verify what exactly is stored there.

Trevor