1 Reply Latest reply on Jan 30, 2012 12:16 PM by philmodjunk

    Index missing Error



      Index missing Error


      I have 3 table as follows:

      File 1: Lot Number, category, One (value 1), cBlankField

      File 2: Lock Number, Category, cBlankField, One, Quantity, Assigned Lot Number, closed (0 or 1)

      File 3 (Portal File for layout attached to file 1): Lock Number, Quantity


      I want to create a value list for File 2 to show me lock numbers for: 1) all blank/empty assigned lot number and 2) file 1 category = file 2 category and 3) Closed = One. I am using layout from file 1.

      Whan I create the relationship & the value list, I am getting 'index missing' in my data viewer.

        • 1. Re: Index missing Error

          And what does that relationship look like? What fields match? what calculations are you using? (how are they defined?)

          I predict that one of the fields in e that are listed in manage | value lists is an unstored calculation field due to referencing data in a related table. Unstored calculation fields do not have an index and thus cannot be used as a value source for a value list. You'll need to figure out a way to set up either the calculation or a relationship to the table that avoids this issue.