Using ASPNM23
I'm using the standard code
public void Lookup_Selecting(DbField fld, ref string filter) {
if (fld.Name == "MyLookupField") {
fld.Lookup.UserSelect = "SELECT Field1 AS lf, Field2 AS df, Field3 AS df2, '' AS df3, '' AS df4 FROM Table1"; // Modify SELECT
fld.Lookup.UserOrderBy = "Field2 ASC"; // Modify ORDER BY
}
}
I'm trying to display additional fields in the lookup but save only the first two field in the table, but all four fields in my lookup get captured and overrides the field lookup,
How do I save only the first two fields even if lookup displays four fields.
Thanks