Re: verify joins?

kistler@an.hp.com (Jim Kistler) writes: >I need to use verify joins as attributes in several fields of a table >where the fields MAY have the same value entered, but that value MUST be >among the entries in the referenced (joined) table. >When I try to do this, the compiler complains: ># ># The column "xxxxxxxxx" name appears more than once. If you ># wish a column to be duplicated in a form, use the same display field label. ># See error number -2892. >I don't want the column to be duplicated, only the "value" in the column(s). >The columns with like values are entered at different times and are used >for maintaining a history of status changes of the record, saved in the >table, itself. This sounds as if you need to use a verify LOOKUP: f010 = sometable.somecolumn, LOOKUP *JOINING othertable.othercolumn; If you want to display something from Othertable, amend this too: f010 = sometable.somecolumn, LOOKUP l010 = othertable.yetanothercolumn *JOINING othertable.othercolumn; With LOOKUP, you can have multiple, independent references to the same column. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>