Hi everyone. I am trying to display an expiry date editable field which is present in Item details (InventTable) in a form On-Hand.
I have added InventTable as data source in the form. The remaining fields are from InventSum table. The relation is mapping of the itemid field which is common to both tables as attached below.

I am using the following to display the expiry date into date field ExpDate using the following:
display Date ExpDate()
{
return InventTable::find(Inventsum.ItemId).ExpiryDate;
}
The field is showing up in the form but none of the entered expiry dates are being shown.
Please advice on how I could fix this or where I have gone wrong. Thanks!
*This post is locked for comments
I have the same question (0)