Matching two fields inexactly

[Michael Thomas]

I am a relatively new FM (5.0) user so if I

[Chuck]

Is the relationship based on the Material field? If not, build the relationship this way, and then try using the lookup technique with next higher selected. This should work.

Chuck

[Michael Thomas]

quote:

---

Originally posted by Chuck:

[QB]Is the relationship based on the Material field? If not, build the relationship this way, and then try using the lookup technique with next higher selected. This should work.

---

When I originally tried this, I only based the relationship on just the Material field (wood, metal, etc) which didn't work because it just returned the first record matching "wood" without taking into acount the length I needed. I went back and reread my question and realized that I should concatenate the Material and Length field for the relationship (and the Material and Size field in the related file)then try using the lookup technique with next higher selected (which is what I now realize you suggested.) I did have to add leading zeros to make everything sorted properly. I still need to have some way to make sure that the chosen, next higher value doesn't roll over into the next material category (i.e. bigger than "metal55" so it chooses "nylon01".) But I think I can put in a record with a default upper limit that will never be exceeded to do this.

Thanks Chuck, I appreciate the help. Sometimes it's all in how you word the question!

Mike