Need some help, please.

[dburgessjr]

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.

[flapjacks]

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

John

[dburgessjr]

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

[flapjacks]

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

[dburgessjr]

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

[flapjacks]

Here it is back to ya with notes and changes.

John

[flapjacks]

Sorry I hit quick reply.

John

1138554959-ex1.zip

[dburgessjr]

thanks for you time... I understand now.

[flapjacks]

Been there done that. I knew you would.

Your welcome.

John