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

[benlinkknilneb]

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!
Ben

 

[lespaul]

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)

HTH



Leslie
landrews@metrocourt.state.nm.us

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