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?