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>