Hi all, I’m trying to set filters on a report i’m creating. I’ve designed a request form that has a lookup box looking at the Job Periods table. This returns the Period Code to the lookup box that the user selects. I don’t actually want to use this Period Code as part of the filter, instead i wish to use the Period Start Date in the same Job Periods table that th Period Code relates to. I was wondering how do I reference this Period Start date value from the Period Code? Rich. (Running Navision 3.70 on SQL Server.)
If I remember rightly, Period Codes is a UK localization, so I don’t have the actual code. But in general, you are going to need to write code that gets the Period Code record, and then finds the appropriate date field, and then applyes that data as a filter on the report.