1 of 1 people found this helpful
Looks like you have your inequality operators wrong:
People::SoleSize >= ShoeSize::SizeFrom AND
People::SoleSize <= ShoeSize::SizeTo
At least, I would assume that SizeFrom has the minimum size and SizeTo would have the maximum size. This also assumes that these fields are of type number. The inequalities might not work if these fields are text.
You can also get this to work with just one pair of match fields if you use a sorted relationship.
But with the correct relationship, you can refer to data in ShoeSize simply by referencing the Tableoccurrence::FieldName such as
Note that the same relationship can be used to either look up (copy over) data or just link to it "live" via the relationship. It depends on what you need to do with this data as to whether it is better to look up or not to look up (copy) the data from this ShoeSize table.
Thank you Philmodjunk! Just had to switch my greater then or equel to around and that did the trick. I had already made the referance to the TO in my lookup calc. Thank you thank you.