Hi, please try downloading the file.

Add an item to the todo... works fine, right? Empties out of the entry field and goes down into the portal list.

Now, go into define database and add a new text field to the ToDo table, called anything.

Now try adding a new record to the todo list.

Doesn't work, right? What the heck is going on?

Thanks,

Andrew

Log.fp7.zip

Hi picnichouse !

I think I found the problem.

You Have auto enter calculations on both Your fields "MainId"

and on "MainidTemp" which depend on each other and depend on the order of the calculation . (a kind of circular reference ).

By adding a new field ( or even opening one of the calculation again) , Filemaker changes the order of the calculation and give You an other result.

You can not realy define in which order FM calculates the fields (?)

Actually Your MainidTemp stays at that old value and does not get set to “0” what You want.

Solution (maybe) well don't use circular calculations use a button e.g “Set” because actually when You input a new record and hit the window outside the next field You also “commit that record now

By the way I just made a new layout with all the fields of ToDo so it was very easy to see that MainidTemp did not get changed.

take care ;-)

Did you develop what you posted, or is this part of another solution?

I developed it, using a technique in the book Filemaker 7 Unlimited, or something like that.

I suppose I can do it using a button, but it was kind of a nice feature, to be able to hit return and have to go in the portal in the correct order.

Maybe this is something that Filemaker 8 broke... I never had any problems with this file (and you can see, I used the same technique in three or four tables) until I tried modifying it with 8.

Strange.

Are you talking about having to commit the record before it is added to the Related file?