how to display original field value instead of lookup field

[jtandrea]

Hi,
I'm stuck with a simple problem.

I have a field (say field1) which is normally displayed (on LIST, ADD, VIEW and EDIT Page), using a lookup table (query) field, say field2 (which is made of two fields joined together).

field1 = "x1"
field2 = "x1 - description detail"

How can I display the original field1 value ("x1") on the LIST VIEW instead of looked up field2 ("x1 - description detail") ?

can you please help?

btw I'm using VB.NET - ASP.NET Maker 12.0.2.

thanks in advance.
andy

[jtandrea]

ok, solved.

   If CurrentPageID() = "list" Or CurrentPageID = "view" Then
                  CurrentTable.<Field>.ViewValue = CurrentTable.<Field>.CurrentValue
   End If

andy