NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on February 01, 2012, 11:28:58 PM

Title: Getting the productID as well as the description when using a lookup
Post by: terryd on February 01, 2012, 11:28:58 PM

I am calling a lookup on a table Product to assign a value to   APP:ProductID. I have the 'DisplayDescription instead of value 'checked.
The value assigned to  APP:ProductID is the description rather than the value after the lookup.
I understand this and I assume that when the record is written away the ID value is substituted for the Description which is why the Description in the Product table has to be unique .
This however causes a problem in a calculation taking place after the APP form is reloaded since it uses a CASE OF based on the productID as a Long, rather than a string
I have to use the lookup because I need to populate some other fields from the product table so AFAIK a drop will not  not work.
I would like to use 'DisplayDescription instead of value ' since it looks better on the screen
Is there a way to get the productID value via the template?
I tried created a local variable and using the  more assignments list to get the productID but I don;t seem to get a value back.

Title: Re: Getting the productID as well as the description when using a lookup
Post by: bruce2 on February 02, 2012, 11:52:59 AM

In the AfterLookup embed, in NT6, the actual record is loaded, so you can do extra work there.

Cheers
Bruce

Title: Re: Getting the productID as well as the description when using a lookup
Post by: terryd on February 03, 2012, 02:34:12 AM

Thanks Bruce