AnsweredAssumed Answered

Multiplication error

Question asked by WesleySantiago on Jun 25, 2013
Latest reply on Jul 1, 2013 by philmodjunk


Multiplication error


     My exercise database has two tables. One is dedicated to lifts, the other is for weight.

     Inside the main lifts table, I'm trying to multiply field repetitions (a number value) by weight (another number value) and getting incorrect results. The weight field is a pop-up field pulling values from the weight table. As I understand it, filemaker is multiplying true repetitions by the ID reference of weight, not weight itself.

     What's the best way to correct this?