AnsweredAssumed Answered

If statement using two tables

Question asked by tomo17 on Jan 27, 2012
Latest reply on Jan 28, 2012 by tomo17

Title

If statement using two tables

Post

i have fields from two tables on one layout and i am trying to calculate a text result based on these fields.  when i try to use the "IF" function it seems to only look at one of the fields.  I have tried nesting the conditions, using OR and the case formula.  if i change the order of the "or" statement ie field 1 second and field 2 first it will look at the other records that it previously did not calculate.

Athlete List::House Colour                  Team Name             cName 

 

This is the formula i have tried to use:

 

If(Team Name or Athlete List::House Colour ="Red";"Rice"; If(Team Name or Athlete List::House Colour ="Green";"Pascoe"; If(Team Name or Athlete List::House Colour="Blue"; "McAuley"; If(Team Name or Athlete List::House Colour="Gold";"Kelly"))))

 

Thanks

Outcomes