Look-up in IWP

[ayurgal]

I've been through most of this forum. Looks like IWP doesn't like lookups. I have a caculation that combines a document tracking number and an illustration number to make a file name something like this:

C154-001

C154-002

...

C155-001

C155-002

...

All the illustrations for a particular document start at 001. This relys on a lookup of the document number to find the last illustration. Everything works just fine in Filemaker. When I publish it to IWP, everything breaks down.

Any help would be great.

I'm using FileMaker 7.

[Keith M. Davie]

Calculations should be unstored.

[ayurgal]

They are unstored. The trouble is, to find the next number in the series I currently need to do a lookup. Everything that I've been reading is that I can't do a lookup from the web interface. Somebody did mention that there should be a way around this using a caculation. That's what I'm looking for. Any help would be great. Thanks.

[aklodner]

You're right, the lookup in IWP seems to not update. But, if you make a calculated field that uses the new Lookup() function, that will work once you commit the record.

HTH

Adam

[ayurgal]

thanks. i'll look into the new lookup function and the lookupnext function as well.

[ayurgal]

I know this doesn't belong here, but I just noticed this:

"FSA: Not a Memember"

You might want to do a spell check on this title. ;-)