Hi All,

I'm new to .NET and trying to display a lookup value in a WinForm textbox.

In VFP, I would put something like this in the Refresh() method of a readonly textbox to show the ProductName as I navigated through the OrderDetail table:

IIF(SEEK(OrderDetail.ProductID,'Product','ProductID'),Product.ProductName,'')

An alternative in VFP is to SET RELATION between the OrderDetail and Product tables and bind the textbox to the Product.ProductName.

How is this best done in .NET?

TIA,