In report show only entity that link to other module

[addady2]

Hi,

I added a link field from "Purchase Order" order to Opportunity.
Now I want to create from "Inventory Details" module item report of all the items in "Purchase Order" that link to specific Opportunity.

How to identify the Opportunity.  It not allow to put text, the popup error is:
"Invalid  my-opportunity-field-name (Integer Criteria)0"
I guess I should enter the number on the Opportunity in the system.

In this example 8547

Code:

index.php?module=Potentials&parenttab=ptab&action=DetailView&record=8547

But when I enter any Opportunity number it fail to bring any result always empty report.

Is it a bug or I'm doing something wrong?

[joebordes]

find the field you have created in the vtiger_field table and change the column typeofdata from I~O to V~O and let me know if it works

[addady2]

It solve the problem !

Thank you

[joebordes]

:-)