Relationship will not work because the field cannot be index

[damon_albran]

Hi everyone,

I cannot create one relationship because filemaker says one of my related field cannot be indexed, and the reason for my field cannot be indexed is my calculation field that calculate a value from another relationship. So, what can i do? Any suggestion will be much appreciated.

[Vaughan]

Use a lookup instead of a related field.

The downside is that modified values won't automatically transfer across, so you'll have to analyse the impact (if any) and work something out, say, a script to "update" buy re-looking up the records when a master record changes.

[damon_albran]

I cannot use lookup to replace caculation.

Let me explain more, a field I named "Status" in a order file which is a calculation field, it will returns "Complete" when all its related orderitem balance qty = 0, else show "Incomplete". the orderitem balance qty is also calculated by the another file invoiceitem. I cannot use lookup for "Status" because it need to change automatically depends on invoiceitem file.

What I really want to accomplish is build a value list which only show incomlete order id. Please help!