hello
We have user defined fields in an equipment table. They could be Alpha, Date or Amt. We created a new Alpha field in the software program for equipment xref numbers.
I have a table with 6 fields that store the user defined info.
Company
Equipment
UserDefinedSequence
Alpha_Field
Date_Field
Amount_Field
The field called "UserDefinedSequence" stores an ID number for the users defined fields. "Alpha_Field" holds the xref number we are trying to get.
Right now we are using 2 user defined Alpha fields in the software so there is 2 codes in the UserDefinedSequence field (000018 and 000070).
The info is stored in the Alpha_Field.
When I run the report for Equipement # 1000... I get
EQ# Seq# XREF#
1000 000018
1000 000070 3056
Here is my formula:
whileprintingrecords;
iif ({EC_EQP_USER_DEF_FLDS_MC.User_Def_Sequence}="000070",{EC_EQP_USER_DEF_FLDS_MC.Alpha_Field},"")
I need the formula to return just on row showing a xref # if it has one or not.
thanks
Rick