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.

Calculations should be unstored.

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.

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

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

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. ;-)