Kinda new to FM so I dont know what I would search for for help. I've been going along making things up and figuring things out on my own but this one problem I cant quite get.

Heres what I got so far:

I have 2 seperate FM files. One called, Expenses. One called, Purchase Orders.

Inside 'Purchase Order' I have a field that calculates material costs based on X number of colors (supplied from another field in the purchase order file) with a total calculated number from a field inside the 'Expenses' file.

So what I would like to do is, at any point be able to update the material cost in 'Expenses' and the calculation in 'Purchase Order' update also with the new number.

The way I was trying to do it kept giving me any answer of 0 (zero) no matter what the total material cost came out to. In 'Purchase Order' under the define field, material cost is a calculation with the option:

Number of Color * Expenses::cost_total

Any Ideas?

Thanks Kindly.

Post an example file and maybe I can help. Make a copy with sample data and be sure to zip it.

John

thanks for replying. attached is an example file for your review. it seems easy what I am trying to do but cant get it to work correctly.

ex1.zip

dburger

Your gonna hate me. You have no value in the Id field of either file. This is how the relationship is created. Put a 1 in the Id field for each file and you will see the rest is written properly.

John

could you please supply the files back with the changes already made. I've tried what I think you are talking about but its not working for me still.

thanks

Here it is back to ya with notes and changes.

John

Sorry I hit quick reply.

John

1138554959-ex1.zip

thanks for you time... I understand now.

Been there done that. I knew you would.

Your welcome.

John