Hi everyone,

I'll describe the whole situation so you can better understand my goal:
I have a work table, aliased as BldMstr in an application. This BldMstr table has a field (Char 2) called DeedType. We also have a lookup table, called DeedType, which has Code (PK) and FullName (description).

I want to show DeedType field in a grid. This is the only one editable field (all other columns will be Read-Only). I want to use ComboBox for the current record. For all other records I'd like to show description rather than code, but I don't want to set Sparse=.t. and use combobox. Another little problem - user should be able to select blank value (it's already in a DeedType table) and the description should show nothing (it now says in FullName field of DeedType table), and the field value in a BldMstr table should become .NULL. (I set nulldisplay to "").

Could it be done, as I want? If so, could you please give me some advices (code samples)?

Thanks in advance.

If it's not broken, fix it until it is.


My Blog