Option Variables in a Report

sabzam

Dear All,

I have compiled a report for which I will be setting a request form. I need to create a variable which is directly linked to the No. Field in the Customer table. In other words I want to force the user to enter solely a No. whcih exist in the customer table. How should this be done; have I got to do it through coding or is there a property or something of the sort?

Albertvh

Hi,

Declare your variable and on the Request form you do the following

create a textbox with SourceExpr MyVariable and set TableRelation to Customer


Hope this helps

Albert

sabzam

Hi,

I have just found it out - after a LONG search of all Navision reports. I have done exactly as you've told me. Thanks anyway for your help.