Solved

filemaker sales chart

Posted on 2007-03-26
4
543 Views
Last Modified: 2008-02-01
hi, before i asked how to make individual sales chart.
i'm having trouble.
i have three table...product DB, invoice DB and invoice data DB.
since one invoice contain multiple product sales data, i made invoice data DB.
now i made a link between invoice data DB and product DB, trying to use SUM script...
but i said error... missing index... do you know how to solve this problem?
0
Comment
Question by:Hiroyuki Tamura
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:JoJohn2004
ID: 18826696
A missing index can be caused by not being able to index one of the fields that are being used as a key field in a relationship. A global cannot be indexed nor can an unstored value. Unstored calculated values will be any calculated field that is dependent on a global, a related field, or another unstored value.
0
 

Author Comment

by:Hiroyuki Tamura
ID: 18826775
thank you.
this is my sample file...
could you take a look?
https://filedb.experts-exchange.com/incoming/ee-stuff/3044-test1.zip 
0
 
LVL 6

Accepted Solution

by:
JoJohn2004 earned 125 total points
ID: 18829134
Create a sum field in Products total=Sum(invoice data::price)

You can then show this field either on the products page or within the portal on the appropriate portal line of the invoices layout.
0
 

Author Comment

by:Hiroyuki Tamura
ID: 18957971
thank you.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question