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?