WEB Publishing scripts based on find results
I'm new at FileMaker so I'm sure there is a way to do this and I need help.
I creating a FileMaker 10 database to be accessed on the WEB. I need to do a find for a part number and if it doesn't exist I need to create a new record to accommodate the new part number. I worked it up on a MAC using Set Error Capture and an IF statement based on the error number "Get(LastError)". This worked fine until I put it up on the WEB. When I check compatablity on Set Error Capture the documentation indicates it doesn't work the same on the WEB.
I need some kind of work around for this situation because alot of what I'm doing depends on this situation.
Try checking get ( FoundCount )
If no records were found the found count will be zero.