Search By Record Number

[drdigital9]

This seems like a simple thing.

On my CDML page, I would like to allow the user to enter a number in a Form Field Box, hit submit, and it takes them to that record number.

As our data base grows, this will make a handy way to navigate.

Any ideas?

[drdigital9]

Great Solution! Thanks

[drdigital9]

I haven't tried this yet, but.....

What happens if you delete a record? I tend to believe there would be a "hole" in that space after deletion.

So if you delete record 22 of 30, 22 would be gone and result in an error if searched for?

Correct?

Any thoughts?

[John May - Point In Space]

Correct - but you could put in a catch for that to explain to the user the record has been deleted.

- John

[John May - Point In Space]

Make a field in your database that is auto-enter serial number. Then, display that on the records page for the user's reference. Then, in your search, just search on that field.

- John

[Partha]

Just wondering, but wouldn't the "-RecID" command be easier to go to a specific record?

Regards, Partha