look up gets strange results

Discussion created by memanic on Nov 15, 2013
Latest reply on Nov 19, 2013 by alquimby

Hello all!


I once again have a problem and I'm reaoly grateful for this forum. Here's the problem:


I have 2 tables with a match field of Item Name. The second table looks up Item Value from the first table. After a couple of week that part was working perfectly. Then I must have changed something while trying to populate the donations table. Now I get strange results: sometimes it works, sometimes not. And sometimes the looked up value doesn't show, but the calculation based on it does. I'm sure it's something simple, but can't for the life of me figure it out. Help please?


Pat R.