How to get Fields to appear based upon another field value?

[JimDiGrip]

Hi,

I am struggling to build a relatively simple application for my father. Please forgive me if this is an obvious question.

I would like certain fields to 'appear' or only become 'active' if a related field (in the same database) contains a certain value.

So, if the field PASSPORT_CHECKED contains the value YES

I would like another field PASSPORT_NUMBER to become active.

I find it confusing when the PASSPORT_NUMBER field is active even if PASSPORT_CHECKED is set to NO.

Am I missing something very basic here?

Thanks

James

[LiveOak]

There is a "trick" you can use to do this. Create two fields:

One (calculation, number, indexed) = 1

Show (calculation, number, indexed) =

(PASPORT_CHECKED = "YES")

Create a self relationship with Show <---> One

Create a single row portal with lines and fill set to transparent. Place the PASSPORT_NUMBER field and its field label inside the portal (NOT the REL::PASPORT_NUMBER field, just the PASSPORT_NUMBER field).

When the relationship is invalid (Show = 0), the contents of the portal will be hidden.

-bd

[JimDiGrip]

Thanks for the reply... it sounds like this is not a simple problem!

I will try it out!

James

[andygaunt]

You could also write a script to do this.

It won't make the passport number field appear or disappear like live oaks, but you won't be able to enter any information into the passport number if the passport checked is not yes.

Script - Passport number

If (Passport checked = "No")

Exit Script

Else

Go to field {Passport number}

Endif.

In layout mode, select your passport number field and choose format button, then choose perform script Passport number.

Set the option to exit.