Start Free Trial

Hiroyuki Tamura

asked on 3/27/2007

filemaker sales chart

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?

Last Comment

Hiroyuki Tamura

4/23/2007

3/30/2007

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.

Hiroyuki Tamura

3/30/2007

ASKER

thank you.
this is my sample file...
could you take a look?
https://filedb.experts-exchange.com/incoming/ee-stuff/3044-test1.zip

ASKER CERTIFIED SOLUTION

3/31/2007

Blurred text

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Hiroyuki Tamura

4/23/2007

ASKER

thank you.

FileMaker Pro

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.

4K

Questions

--

Followers

--

Top Experts

Get a personalized solution from industry experts

Ask the experts

"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23
"Your help has saved me hundreds of hours of internet surfing."
@fblack61
"Just a dang good service!"
@golferski
"Worth every penny."
Steve Hougom
"It’s been a life saver."
Maria Halt
"Best support site I’ve seen!"
Bob Schneider
"I would be lost without them."
@fblack61
"Saved my job multiple times."
Walt Forbes
"I love this site."
Maria Duwe
"Friendly respectful help."
Andrew Kowtalo
"Such top-notch experts."
@magento
"The best money I have ever spent."
@rwheeler23
"Beyond any comprehensible value"
George Morris
"Invaluable tool for our organization"
Josh Regalski
"This is the best money I have ever spent."
@rwheeler23

Read over 600 more reviews

TRUSTED BY