Define a calc

[mdpres]

I have a vey straight forward calc in a parent file (or so I thought).

Case(Related Record 1::text field 1 = "" and Related Record 1::date field 1 > 01/01/1998,"X",

Related Record 2::text field 2 = "" and Related Record 2::date field 2 > 01/01/1998,"X",

Related Record 3::text field 3 = "" and Related Record 3::date field 3 > 01/01/1998,"X",

Related Record 4::text field 4 = "" and Related Record 4::date field 4 > 01/01/1998,"X","")

I have set this up on OS X (10.2.6) & Win XP (Home Edition) the field defines properly (no circular definition) msg, but when I go back to browse mode I get a spinning circle in OSX or an hour glass in Windows After 10 to 15 minutes I force quit. Anyone have an idea?

Dean

[ernst]

Hi Dean,

This sounds/ looks weird.

Though the calculations might need some brackets to give the result I think you'r trying to achieve, this should NOT be the reason to go into an endless loop.

Can you attach a stripped down version of the database?

Regards,

Ernst.

[Fitch]

Could be the date. Try using TextToDate (01/01/1998) or Date(1,1,1998).

Also the preferred syntax these days for ="" would be IsEmpty(Related Record 1::text field 1).

And last but not least, what is the relationship based on?

You use 4 different relationships and 4 different text fields? and 4 different date fields?

[mdpres]

Tom,

I was doing some of the calc from memory I do have Related Record 1::field 1 as IsEmpty, I have tried date all ways I can think of. The 4 relationships are based on 4 possible numbers. I set up 2 test files and was able to get them working, I am going to go back over my calcs and see if any are wrong (again).

Thanks for the replies as soon as I am happy with my test files I will post them.

Dean