Please excuse my ignorance as I am new to Notes/Domino.
How would I link a document from one database to another database so that when I select for example a customer name or number on a form, it would automatically fill in all the other relevant details on the form, i.e. the phone number, sales representative etc from the other database.
If you understand my scenario please help by supplying a solution, or an alternative way of solving my problem.
Subject: Linking documents and fields between databases
Notes provides a few functions and wot-not that will let you achieve your aim easily. Read up on @DbLookup and @DbColumn. If you’re approaching the issue from more of a VB-mindset, or indeed Java, then the Lotusscript / Java functions / methods GetDocumentByKey and GetEntryByKey will help.
Essentially you use a value in your current document as a “key” to getting a handle on a document in another database. Once you have this handle, you can pull throuhg data from that other document and write it to your current one.
There’s more to it than all this of course: optimising look-ups, performing one look-up to populate more than one field, etc., etc., but this is a starting point.