Field3 = ""Yes" ;
List ( Relationship::Field1 ) ;
That does work, but it then lists all valuse from Field1.
Is there a way to list only the values from records where Field3=Yes? THey are both on the same table.
Sorry: don't understand. Field1 and Field3 are in the same (Parent) Table?
So if Field3 in the Parent Table record is 'Yes', Field2 in the Parent Table lists all the related values to that Parent Table record of Field1 in the related table.
If Field3 is 'No' it does not list any related fields.
Not clear what you mean instead of that.
Include yes as part of the relationship between the two tables and then list will only list those values where the value in field 3 is "yes".
Parent::PrimaryKey = ChildYes::ForeignKey AND
Parent::constYes = ChildYes::Field3
Then a calculation field in parent defined as:
List ( childYes::Field1 )
will return only those related records where Field3 = yes due to the fact that only records where the value of field 3 is yes can be related in this relationship.
constYes can be defined as a calculation field with "Yes" (in quotes) as the calcualtion expression so that this field has the same value for all records in Parent.
ChildYes can be a new occurrence of Child if needed in order to keep an existing relationship between Parent and Child from being modified.