Portals display on current records but not new.

[GaryA]

Hello, I am still pretty new to Filemaker but have done a ton of reading.

Anyways I have a MYSQL database that I am working with that is used for lets say keeping track of stuff. What I have are a lot of fields that depend on the previous field. So I put them in Portals and I have Calculation fields set up and also relationships set up.

The problem is that on new records the Portals will not display when the correct previous field is set. However on existing records on the database the Portals work fine. I have played around with setting the Allow records to be created option for the relationships also.

An example of one of my calculation fields:

case_notes(this is the field) = Case(case_disposition="Other";id;"")

So basically what should happen is the Case_notes would be set if the case_disposition field is set to Other.

Any help is much appreciated.

Gary

[GaryA]

I think I know why they do not show up on a new record. It is because the id is not set yet. So now I have to come up with a way to reference the current record or something like that.

Would I be able to create a field that gets the previous record number and adds 1 to it. Then reference this field for my other calculation fields instead of id?? Although I would not want this new field visible either.

Edited July 8, 2009 by Guest

[GaryA]

Nevermind. I got it figured out. Just had to have a script run that commits a new record when it is created. This way the id is set right away and is able to be used for the Calculations and the relationships to show or hide the portals.