AnsweredAssumed Answered

Relationship finds no records

Question asked by davec on May 22, 2012
Latest reply on May 22, 2012 by philmodjunk


Relationship finds no records


I have two tables Invoices and home. I want to have a value list for only those Invoices over a certain amount of money.

What I have done is:

1) created a calculation field "i_expensive" in Invoices to be 1 if the total is high and 0 if not.

2) created a global field "g_highcost" in my home table set to be the dollar amount.

3) defined a relationship between these fields.

4) made a value list of "i_ID" fileds through the relationship with the home table. 

What I don't understand is why there are no records in the value list. I've tried to create a portal to see what the issue might be but can't figure it out. I am sure I have the right table occurances. What have I missed?