The Data Directive executes when the HDCase record is stored or updated, so this code won't execute until you save the record. You may want to move this to the method where a serial number is retrieved. If you assign the fields from the serialno record to the tthdcase.character01 and tthdcase.character02 fields it should store the values you want.
--- In vantage@yahoogroups.com, Ken Dumesnil <ken.dumesnil@...> wrote:
>
> Hi,
> Â
> Hopefully someone can help with this.  I'm trying to display 2 UD fields from the SerialNo table onto the HDCase (Case Management) table going to 2 UD fields. I created a data directive for in transactions and entered the following code in the Condition Tab. I'm using the SerialNo field as a link between the tables.
> Â
> for each HDCase no-lock , each SerialNo no-lock where (HDCase.SerialNumber = SerialNo.SerialNumber ).
> assign HDCase.Character02=SerialNo.Character02.
> assign HDCase.Character03=SerialNo.Character03.
> END.
> Â
> For some reason when I call up a serial in Case Enrtry the part number (standard product) comes across and displays but my 2 UD field do not.  Any Ideals?
> Â
> Thanks,
> Â
> Ken
>
> [Non-text portions of this message have been removed]
>