I am stumped why this isn't working. I hope someone here can help. I have 2 tables. Table 1 has a field named "Value". Table 2 has fields named "Total set value", "Value used", and "Value left". I have a simple script that checks to see if Value in table 1 + the Value used in table 2 is > than Value left in table 2. It looks like this

If[(Table 1::Value + Table 2::Value used) > Table 2::Value left]

Beep

End If

My problem is that the computer continues to think that Value + Value used is always > than Value left. Even if Value is set to 1, Value used is set to 2, and Value left is set to 100. Maybe I'm missing something. Any help given is much appreciated.

Heathbo

How are the two tables related?

I have a join file between the two. The join file is used to show records from Table 1 in a portal in Table 2. The Field "Value Used"(in table 2) is a calculation that sums all the numeric values of the records in the portal. The Field "Value" is just a text field that automatically enters 450 when a new record is created. The field "Value Left" is a calculation field that calculates Value - Value Used. I have a script that transfers records from Table 1 into the Portal in Table 2. What I'm trying to do is put an if statement in the script that checks to see if by adding this record to the portal, will the "Value Used" be higher than the amount limit in the field "Value". If it exceeds the limit I want a display to come up and say, adding this will increase the cost beyond the limit set "450"

I hop this makes sence. Thanks for any help you can give me.

moved to appropriate forum

http://www.fmforums.com/threads/showflat...SID=#Post136262