Jump to content

A general layout with all the tables of the database


edudna
 Share

This topic is 5758 days old. Please don't post here. Open a new topic instead.

Recommended Posts

If someone can help to find a respectable solution to this problem:

I have some groups of costumers, for example costumers from five different countries. The costumers have orders all the year. And the orders have of course prices.

I want to show in the same layout:

For a specific period, for example 1-9-2006 until 12-12-2006

By a specific group of costumers.

All the costumers, all the orders companied and all the prices of the orders. Without some fields repeated again and again.

A general layout for all the tables I have.

Pascal

Link to comment
Share on other sites

Use a sub-summary report based in the most granular table, either your Orders or Line Items table. You can Find for Orders in that Date range with Customers in a specified Group, and sub-summarize by Group, then by Customer, then by Order or whatever.

Link to comment
Share on other sites

Thank you for your response,

I will test it and I will be back. As I understand Sub-summaries are the basic concept Key in File maker Pro to create any layout. However some elements need more complicated layout than Filemaker can do or I do not know still what Filemaker can do...

Pascal

Link to comment
Share on other sites

This topic is 5758 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.