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

New to Notes: What's the easiest way to...

New to Notes: What's the easiest way to...

New to Notes: What's the easiest way to...

Hi all,

I have "inherited" a database used in our plant's shipping department.  Our manufacturing process is being altered so that we are not allowed to print a shipping tag until a certain quality test is complete.  I have the data from the quality test in another department's database.  I've never used Notes Designer before; all my previous programs have been in VB/Access.  How can I use information from one Notes DB in another; and, once I've got it into the shipping database, how can I look for the existence of a record associated with this shipping tag (associated by 2 fields: 'partnumber' and 'productiondate')?  

Thanks in advance!

RE: New to Notes: What's the easiest way to...

First off, you need to realize that Notes is VERY different from Access.  Access is a relational database and Notes is a document database.  Each document is made up of fields.  Individual documents are displayed in forms, multiple documents are displayed in views or folders.

What you are trying to do isn't that difficult.  First, read through threads in this forum and look at the code.

In the Quality Control database there should be a view that has the documents indexed by your partnumber, productiondate criteria (if not create one). In your database, you can access that database (there are plenty of examples here on how to connect to another notes database) and search the view, if a matching document is found, then you can create the new document in the shipping database.  You can even use the values from the QA database to fill in portions of your shipping document if that is something you require to minimize manual entry and errors.

Search the forum for Learn Notes (I know I have written some lengthy Notes Introductions that should help you with some of the concepts)



There are 10 types of people in the world -
those who understand binary
those who don't!

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