Creating 1 Dashboard for multiple databases

[Scott Pon]

I am running Filemaker Server11 (standard) with Filemaker 11 Pro and Filemaker 11 Pro Advance.

 

My company has asked to create a dashboard that will display information from with multiple databases.  Some possible information:

How many orders/value of orders that are still in house

How many quotes were created and open (not booked)

How many orders have problems

 

Each one of those would come from a different database, however they are all linked together, Quotes->Orders->Problems.

 

Any ideas how this might be accomplished?  I'm at a loss on how I would do this.

 

if there's a 3rd party software that can be customized I can research into that too.  

 

I'm on FM11, are there new features in 13 that can do this?  

 

Thanks.  I'm open to discussion and options.

Scott

 

[eos]

Each one of those would come from a different database, however they are all linked together, Quotes->Orders->Problems.

 

Do you mean multiple database files, or several tables in one file (or a combination thereof)?

 

Any ideas how this might be accomplished?  I'm at a loss on how I would do this.

 

Are you really an expert?   

[Scott Pon]

Each one is a separate database.  I only mention 3 databases, but the dashboard can get complex with showing 6+ databases showing multiple types of information.

 

There's no need to attack me.  Yes I'm an expert, I've created many complex databases and linked them through relationships.  But I don't know everything. otherwise I wouldn't be on this forum trying to develop a solution.  I'm looking for ideas, not insults.

[IdealData]

Relationships and portals will provide good summary lists. Use the portal rows as spring boards to open the more detailed view in the other files.

Use the Go To Related Record script step to launch into the other files.

HTH

[Scott Pon]

I created a table for my dashboard layout, with one field "Static 0" Type calculation, formula "0"  then when i created my summary tables.  To get my tables onto the dashboard layout, each summary table has a field that calculates to 0.  then a relationship from the field and the "Static 0"  that's the only way I can think of to get multiple tables (most likely unrelated) to show up on one layout.

[comment]

I created a table for my dashboard layout, with one field "Static 0" Type calculation, formula "0"  then when i created my summary tables.  To get my tables onto the dashboard layout, each summary table has a field that calculates to 0.  then a relationship from the field and the "Static 0"  that's the only way I can think of to get multiple tables (most likely unrelated) to show up on one layout.

 

This technique became obsolete when the x relational operator was introduced in version 7.

http://www.filemaker.com/help/13/fmp/en/html/relational.11.8.html#1028014