Search by given file id in table

[Rushhour]

Hi.. Each record created by user will be auto assigned a file id. And i have a layout to show all the info of the records in table form, 1 of the field which is the file id.

e.g. i wish to obtain record by a search lets say the file id is 1222, how can i actually do it? call for the form layout and search by file id on the layout..??

Help needed..

Thanks a lot..

Kelvin

[Inky Phil]

Kelvin

a couple of points to consider before you go ahead with this approach.

Firstly it is not usually recommended that you let your users see the record ID. This is best kept working in the background because if you allow them to see it they will find a way to change it and cause all kinds of complications. Best that ID's are kept in the background if poss.

Secondly if you do proceed with searching by record ID because that suits your purpose how is your user going to know which ID they are looking for. If you have 5000 id's how is the user to remember them all? Would it not be better for them to search for something that they might remember eg customer name, product name or any other relevant information?

HTH

Phil

[Rushhour]

Hi Phil..

Hm.. how about i disallow the file id field able to enter in browse mode??

"Secondly if you do proceed with searching by record ID because that suits your purpose how is your user going to know which ID they are looking for. If you have 5000 id's how is the user to remember them all? Would it not be better for them to search for something that they might remember eg customer name, product name or any other relevant information?"

True true.. or i should do all these search in a new layout call 'Search'?? And if my table are having 5000ids, isn't my table will be so so so long.. any advice to tackle on this?

Thanks a lot..

Kelvin

[Inky Phil]

Morning Kelvin,

Yes of course if you disable the record ID in browse mode that would stop them getting at it but that is a layout dependant setting and unless you are very tight in your navigation controls they might still be able to find somewhere to change it.

Best if the user is totally unaware that that field exists at all. I am presuming here (one should never presume I know) that the record ID is just that - the unique record ID that will be used throughout your solution for relationships etc to isolate that one record and that one record alone. If so this is why you need to maintain the integrity of that number.

If on the other hand this record ID is just the number by which everyone within the organisation recognizes any given record then of course you can use it in your search.

With regard to a search routine as I do it I have to say that I am not sure what it is your customer is going to be searching for so it but I will presume (there I go again!) that they are looking for a particular overseas report. If that is the case are they looking for a report for a person or a place or both or a date or just a record ID.

Let me know the kind of thing they might be looking for and then I will go through what I would do

Regards

Phil

[Rushhour]

Hi Phil,

Really thanks for your tips and advice. Hm.. i dun think record id will be essential in the search but because maybe at time we need to print the doucments out so i guess we will need the file id.

erm.. most likely will be seaching by name and department..

And if my table are having 5000ids, isn't my table will be so so so long..

Haha thanks a lot phil..

Kelvin

[Rushhour]

Hihi

I will be using list view, user can search through there so not neccesary to a search layout anymore..

But go back to my previous question, if i am having like 5000 records won't my list be very long?? how can i actually break these records into pages??

Thanks a lot..

Kelvin