Self referencing lookup of last modified?

[HALBURN]

I have a "LineItems" database with the following fields:

LineItemID

Qty

LastModFlag (global number)

Whenever the "Qty" is modified I would like the "LastModFlag" to lookup the record's "LineItemID". Is there a way to trigger a lookup that would do this?

[Søren Dyhr]

It's quite easy, what ever the use then will be?

Make an autoenter field with the update option chosen, an stuff following in it:

Case(Qty;LineID;LineID)

or

Evaluate(LineID;Qty)

But perhaps are what you're trying to do this:

http://www.nightwing.com.au/FileMaker/demos8/demo806.html

--sd

[HALBURN]

It's quite easy, what ever the use then will be?

But perhaps are what you're trying to do this:

http://www.nightwing.com.au/FileMaker/demos8/demo806.html

I am using it to build a relationship as part of a navigation system.

The zippscript plug-in looks pretty useful. I am experimenting with it now.

As always, your help is awesome!

Thanks.

[HALBURN]

I thought that I understood what the evaluate function was doing in your previous example...but I guess I don't. Any idea why this lookup would be returning the wrong TimeStamp? I am trying to lookup the current TimeStamp whenever the QtyInvoiceShipped field is modified.

Evaluate ( QtyInvoiceShipped ; CurrentTimeStamp )

is returning

1/1/0001 12:00:01 AM

[Søren Dyhr]

Admitted it could be a little convoluted to grasp...

Evaluate ( Quote(recordID & " | " & Get ( CurrentTimeStamp )); qty)

One thing are fields, but when functions are involved should the whole thing inside a Quote( statement.

What this is more or less the prerequisites for an audit trail, and is indeed a heavily debated subject:

http://www.nightwing.com.au/FileMaker/demos8/demo809.html

If you in the box when reaching this site http://www.databasepros.com/resources.html type "field modification" and it'll bring 4-5 templates at least.

--sd