Comparing a Repeating Field to a non-Repeating Field (FileMaker 5.0 & 5.5)
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!