Jump to content

Self referencing lookup of last modified?


This topic is 6495 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6495 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.