I'm not sure how to phrase this, or which forum to put it on so I'll just start here.

I would like to have my database do the following scenario:

IF value in field (A) = "YES" then value in field (: = "0"

IF value in field (A) = "No" then dialog box prompts you to ENTER VALUE.

IF value in field (A) = "Don't know" then question for field (A) shows up on a separate layout called UNRESOLVED QUESTIONS.

As each question does get resolved I would like to have the requisite answer show up in the originating Layout.

And since we are on a roll here, why not add an ELAPSED TIME field to track how long the question has been UNRESOLVED.

I know this is kind of a laundry list type question but if somebody could help me with any part of it I would be appreciative.

Thank you,

Jarvis

Field Definitions:

B (calculation, number) = Case( A = "Yes", 0, "")

DisplayEnter (calculation, number, stored, indexed) = Case( A = "No", 1, "")

* you don't really need the Case statement here, A = "No" will work as a definition, it's just a little easier to see where I'm going.

DisplayQuestion (calculation, number, stored, indexed) = Case(A = "Don't Know", "The text for your question", "")

kOne (calculation, number, stored, indexed) = 1

Create a self-relationship:

Rel1 with DisplayEnter <---> kOne

You can now use a one line portal with no scroll bars based upon this relationship to enclose the field for data entry (B?). This will cause the field only to be displayed when the second condition is true. The "don't know" condition triggers calculated text which can be placed on the UNRESOLVED QUESTIONS layout. You could use a second relationship to display the text and a field, if there is to be a data entry field associated with this case.

-bd