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

Opening a document using docid

Opening a document using docid

Opening a document using docid


This is my first post and I have a question for you. I hope I can explain this well enough:

In a form I have a list box which populates a field using @dbcolumn lookup. In this case it's the document title in another database...no problem.
What I want to be able to do is after this field is populated either click in the field or use another button to open the said document in the other database. So far all I can manage is to open the other database from the field then scroll down the list of documents to find the one I want - not a problem, but when the database contains several hundred documents - it's a pain.

Is there a way to get the document id (from the title I have just picked in the previous field) then use this to link directly to the document....

Thanks in advance.

RE: Opening a document using docid

What you can do is, in the view you are connecting to for the dblookup, the column where you retrieve your value, you can add an alias to the value you select in the field.


At the moment:
value for column 1 in view = DocumentTitle

try this:

value for column 1 in view =
DocumentTitle | @Text(@DocumentUniqueID)

what this does is, when you select the value in the list, and it shows the document title, and you access that field value in your formula, the value retrieved is actually the Doucment Unique ID and not the document title.

Hope this helps.

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