Suggestions

[fchieli2]

I have one layout that contains job information.

There's one field named Status.

The Status can either be 'not approved' or 'approved' .

If the status is not approved I need the users to see only a few fields, when the status becomes approved, I'd like them to see more fields.

What I did is designing 2 tabs one for not approved and one for approved and using ZippScript I made a script that goes to the right tab when you change the value in the Status field.

All works well until you navigate to the next record. At that point the default tab kicks in whether the status is approved or not...

Should I change my approach to the problem?

Any suggestions?

Thanks!

[mr_vodka]

You may want to look into these although I do try and stay away from EventTriggers:

http://www.zipptools.com/

http://www.fmforums.com/forum/showtopic.php?tid/193376

[David Jondreau]

Create a new field in the table, a calculation field with a text result = "Approved". Creae a TO of the same table and relate the two primary keys together (a self join). To that relationship criterion add

cApproved = Status.

Put a large one row portal on the layout showing the extra fields. They'll only be visible when the status is "Approved".

[fchieli2]

and that's why I love this place!

THANKS!

[fchieli2]

mr_vodka:

Why do try to stay away from event triggers?

Edited February 21, 2008 by Guest

[Fitch]

You can trigger a script when changing records, by putting the trigger calc in custom record access privileges.

[mr_vodka]

I am not saying that I do not use them but sparingly since they are not native to FM. Furthermore, if not properly done it can cause headaches from a management standpoint.