AnsweredAssumed Answered

Comparing a Repeating Field to a non-Repeating Field (FileMaker 5.0

Question asked by agreer on Mar 26, 2010
Latest reply on Mar 26, 2010 by agreer

Title

Comparing a Repeating Field to a non-Repeating Field (FileMaker 5.0 & 5.5)

Post

Hi,

 

I've got 2 tables. In table 1, the Unique Product Number (UPN) is a repeating field, and in table 2 it is not. When the UPN occurs in table 1, I'd like an exclamation point to appear in a second field in table 2. Right now it only works for the first iteration of the UPN. The calculation code for the second field looks like this:

 

If(Extend(Unique Product Number) = <table 1>::Unique Product Number, "!", "")

 

What am I missing? Thanks!

Outcomes