Hello everyone. Well ... I have made the jump. I am moving from MicroCrap to Filemaker. I have purchased both FM9 Advanced and the server addition in an effort to convert several clients in an MSsql environment to a more friendly and hopefully more user friendly FM solution.

But I am having an issue understanding something. Please enlighten me.

I need to make several complex math calculations based on various field data from a single table. These calculations do not need to be stored but rather just displayed to the end user.

In Access I would simply create a text entity and assign a calculation. No muss no fuss.

But in FM I have to create a field for every calculation. This seems like a poor way to design a database. My understanding from the old days of relational DB design is that you never store a calculation unless you intend to further calculate that value.

What am I missing here.

Edited August 17, 200718 yr by Guest

Welcome to FM Forums, TMG Studio!

But in FM I have to create a field for every calculation.

How so? You can create those 'many' calculations within ONE calculation field in MANY ways with FileMaker. In truth, we need a specific example in which to demonstrate. Can you provide us one? Because, having used Access quite a bit, I can assure you that FileMaker can do the same thing just fine. :wink2:

Make the calculation unstored... (and yes, having to create a field for every calc is annoying)... but then again, as LaRetta says, all depends on the situation.

Edited August 17, 200718 yr by Guest