Hi,
I want to make an option popup, where the enduser can select a customer , =NL("lookup";"customer";"name")
For my report I need the customernumber to be returned and not the name of the customer.
So the end users has to see al the available customers, if he selects one, the number has to be returned.
Is this possible and what do I need for formula=
Thanks,
Peter
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Peter,
You can use a formula like this:
=NL("Lookup";"Customer";{"No."\"Name"})
This will display both the customer number and name to your end user, but when they choose a value, only the number will be placed in the value column. If you want to be sure your user sees all the customers, you may want to change the "Lookup sample value limit" and "Lookup record scan limit" in the Application Settings -> General page. These control how many records are scanned and how many values are returned for lookups. If you specify 0 for these values, all values will always be scanned and returned, but beware if you have a lookup to a large table such as the Cust. Ledger Entry that this may take a very long time.
Regards,
Hughes
Please sign in to leave a comment.