Contact US

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!

*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

ODBC Lookup / Search field

ODBC Lookup / Search field

ODBC Lookup / Search field

Hi All

I have a field within an external database that I want to be able to bring into a form, but what I would like to do is have a free text search of this field, for example I would like on my form a search text field where the user can type in a word or description, then they will click on a search button, this will then search through the field on the Associated ODBC linked table and will return a list of items that match this search, the user can then select from the results and this is then returned to a specific field on the form.

How and what is the best way to do this.

Any help is appreciated.



RE: ODBC Lookup / Search field

Would it not be enough to create a Notes db that links to that external field ? You could create a synchronized link to the external db, and have a view you could search in at your leisure from any other db.
Using NotesPump, or DECS, you should be able to set that up without much trouble.


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