×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

search button

search button

search button

(OP)
Hi,

I'am currently doing my HNC and have the task of designing a computer helpdesk system.

In Notes I have a form called usersdata, this form basically has 3 fields on it called username, name and telnumber.  When the form is saved the documents are stored in a view.

I have another form called newcall ,on this form I have a username, name and telnumber field along with a few other fields.  What I would like the user to be able to do is type the first few letters of the username into the field then press the search button. I would like the search button to look at the userdata view and update the fields automatically.

The idea for this is to stop the helpdesk operator having to manually type in all the user details.

Hope that makes some sort of sense, any help would greatly appreciated.

Many thanks

RE: search button

The first problem is simple - make the field that is used to input the user name as a keyword field, taking its values from the list of users. Search will be automatic if the user clicks on the arrow indicator next to the field. It may even work by just typing in the field value.

To have an update, you will have to code a @DbLookup function that opens the second view, searches for the correct document by key, and retrieves the field value you want.

Check the syntaxe on @DbLookup in the Designer Help. Your answer is there.

Pascal.

RE: search button

(OP)
thanks for that, but i dont have the option to create a keyword field. I use lotus domino designer 6.5, the field type i have at the moment is a text field, i can change it to others like a listbox or combobox, but i cant see anything for keyfield?

am i way of the mark?

cheers

RE: search button

(OP)
thanks for that, but i dont have the option to create a keyword field. I use lotus domino designer 6.5, the field type i have at the moment is a text field, i can change it to others like a listbox or combobox, but i cant see anything for keyfield?

am i way off the mark?

cheers

RE: search button

Sorry, "keyword" is the generic name for listboxes, checkboxes, radio buttons and the like. If you already have a keyword field, then you have the option to get it to refresh automatically.
All you need to do is activate it.

Pascal.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close