In Dreamweaver I'm creating a Jump-Menu that will take me to certain items in my database. For the Link I have the following:

http://127.0.0.1:591/fmpro?-db=frames.fp5&-lay=parts&-format=parts.html&-max=368&-recID=127&-find

There are 368 records in the database. The above command works. If I just replace -recID and -Find with -Findall it will show all 368 records.

However if I change -recID=128 or go any higher, Filemaker returns a javascript warning that the file is not found.

I can see records 1 through 127 fine, but then it seems to loose its way. Am I searching the wrong way?

Thanks

Howdy! Yeah.. it's a common mistake. The -recID is an internal number that FM uses to reference records... we're not really supposed to see/use it ourselves. The 128th record may have an id like 32712 or something... you can see it if you put [FMP-CurrentRecID] visible in your web pages.

What you should do is make your own reference ID (auto-serialnumber) and use that instead... sometimes recID and your referenceID will be the same, but more often it will not be as the db grows.

--ST

Thanks for the anwser, Steve

I knew I should have put an ID field in there. Then I thought no I'll be okay without it... I'll go do it right now.

Thanks