Problem with lookup in custom report

tompynation

Hi, i created a Report based on a custom record, nl Recept.

In the DateItem it's properties i have filled up the RequireFilterFields to ask for the ReceptCode...

When i run the report, i see the request form where i have the ability to fill in an ReceptCode... But i can't drilldown to see all available code's

Do you need something special to be able to drill down in the Request Form?

DenSter

The fields needs to have a table relationship into that table, and that table needs to have a lookup form defined.

tompynation

There is already a lookup form

What you mean with the table relation?

SHould i make a relation to itself?

JedrzejT

ReceptCode field in table must have relation to "table". In that "table" must be filled property - LookUpFormID.

If ReceptCode is primary key of "racept" table then just set LookUpFormID property in this table.

einsTeIn.NET

Do you mean a filter field inserted by property ReqFilterFields or by you in the request form on Options tab?

garak

@tompynation:
do you ask so many questions about coding in NAV. Do you has ask your chef for a NAV development course :?:

einsTeIn.NET

Would be better if he would ask his chief :!:

tompynation

i never had a course about navision.

I learn all by myself...

I already passed the first develoment exam. Going for the second one soon