count records

[lastpass]

Hi!

I have tables: 'Orders', 'Quotation' and 'Adress'.

'Orders' and 'Qoutation' can make new records in 'Adress' if user push a button.

I want to FM count the records that contains the same company at the 'Orders' table and show the result in 'adress' table. (wich is in list view).

Example:

No.__Company__order count

1.___Mercedes__10

2.___Audi_______50

etc.

I tried this formula but it's give a fake result:

Count ( List ( Orders::Company); Company )

Anyone can help me?

[bruceR]

Learn about summary fields and basic reporting.

Suggest you try completing the tutorial that comes with FileMaker.

[lastpass]

Yes I have to learn but I read tutorials and practice with tutorial files and I still don't know how can I calculate that sum. I read FM help too and there is no information about using formulas terms.

Example I made the sum of the orders value (total-total sum) and I can't define to omit that record wich is in an other currency. Currency is defined in a separate field and value is always in the same field. I think I want to use a search-calculation but how can I do that?

Calculation formulas exclude search option...

Thank you in advance

[bcooney]

I'm sorry, but I've read and reread your post, and cannot make sense of your data structure. Why would a user create an Address record from a Quote? Addresses are usually tied to Contacts. It also seems that you are not relating tables by key fields (IDs).

If you post the tables and how they are related, we can offer some advice on how to structure (model) your setup properly.

I suggest you study a filtered portal example to see how a relationship could help you "look" into a child table and see only the records that satisfy your criteria.

[PotzUK]

Try:

PatternCount( List( Addresses::CompanyName ) & ¶ ; CompanyNameToCheckFor & ¶ )

[bruceR]

Yes I have to learn but I read tutorials and practice with tutorial files and I still don't know how can I calculate that sum. I read FM help too and there is no information about using formulas terms.

Example I made the sum of the orders value (total-total sum) and I can't define to omit that record wich is in an other currency. Currency is defined in a separate field and value is always in the same field. I think I want to use a search-calculation but how can I do that?

Calculation formulas exclude search option...

Thank you in advance

There is no sum to calculate; you use a summary field and when you use subsummary parts and sort-by, the total shows up for each group.

Go back to the tutorials, about page 63.