how I can get the incident number from problem table.

[ch_naresh207]

How I can get the   incident number from problem record, we attached incidents in problem table . so we have s report is that Incident we need to pull the report from prolem table , I have tried problem table but I cant get the any info. Could you please suggest me.

I have created new table from database view concept, I have tried but thatis not worked. and I written Where clause metthod that is not working.

[Chuck Tomasi · Accepted solution]

The incidents in the related list of a problem are those records on the incident table where the Problem (problem_id) field is the value of the currently displayed problem record. If you want to know which incidents are related to a problem, you need to query the incident table. You can then group by the Problem field.

[rgm276]

Depending upon your reporting needs, you will want to include a filter condition that only looks are recently closed problem records, or open problem records by using the SHOW RELATED FIELDS, choosing problem ==>related fields, and then selecting date or active, etc..       You may also want to include fields from the problem record on your report using the [+] icon on the available fields and expand the problem record to add those fields to the report.

[ch_naresh207]

Thanks lot Robert