Hi

I have created a pop-up menu in a FileMaker 7 database.

The pop-up menu displays values from the value list called Status, which
contains the following custom values:

* Begun
* In process
* Finished

When a user set the menu to "Finished", todays date (//) should be written
in another field.
So that this date can be recalled in the database.

How can that be done?

Thanks

Daniel

NewField = Case(PopUpField = "Finished", Status(CurrentDate), "")
Set it 'unstored'.
Remi-Noel


"D" <d (AT) msn (DOT) com> a écrit dans le message de news:
43158bc6$0$197$edfadb0f (AT) dread11 (DOT) news.tele.dk...

More likely

Case ( PopUpField = "Finished" ; Get(CurrentDate) ; "" )

Except that this will always show today's date. If your idea is to show
the date on which the status was set to "Finished" and keep it that way,
consider using EventScript (free plugin from http://www.softs4humans.com)
to trigger a script which sets the date when the status changes.

Just out of curiosity, what is the difference between "Begun" and "In
Process"? Without specifics to the contrary, I would assume they are one
and the same.

Matt

Remi-Noel Menegaux wrote on (8/31/2005):

Another possibility is to use an auto-enter calculation rather than a
calculation.

So Auto-enter, replace existing value

Case(GetActiveFieldName) = "PopUpField and PopUpField = "Finished";
Get(CurrentDate);"")

Whenever the PopUpField is changed the auto-enter will be triggered and
assuming you do not change it again after "Finished" the date will
stick.

Matt Wills wrote:
--
Dan
Using
FMP7.03, WinXP SP2

Hi Matt

It is an RMA system in which the sales support sets the single case to
"Begun" and fills in the blanks.

The staff at the inventory sets the single case to "In Process" after the
case have been executed.

If the case is unfinished e.g. the customer must return something to us, the
case will be set on "In Process" until the goods are received and the case
is set to "Finished.

/Daniel