I'm a experienced VB/SQL-Server developer who tries to get the "full-picture" about how notes is should be used. (And Lotus' website isn't really helpful here)
What I found out in my first hours with notes (my notes-book comes in 5 days ;)) is that there are two products in a Notes-Setup: Notes Client (NC) and a Domino Server (DS).
Is the relation between NC vs. DS like the one between Outlook vs. Exchange-Server or more like (Outlook + Exchange) vs InternetInformationServer.
ie. is the DS the server notes clients connect to or is it JUST a web-server?
if it is the server notes clients connect to, what do you have to take care of when moving a local <database>.nsf to a Server. (i assume notes/domino does not just use file-sharing ... am i right?)
You could help me as well with understanding the different kinds of Domino-Servers when explaning the software needed for accomplishing the following example-task.
I want to connect a workgroup to several databases (say there are about 10 users). What software do I need when I don't want DS to be the Mail-Server or Web-Server.
I know quite a bit about relational database -- it seems that I have to forget anything here ... ;)
Is it correct that a notes-database could be compared to a single table (more or less) in a relational database system.
(FE.) say I want a form to be filled out with billable hours. I want the user to select a "client" from a dropdown-box and to enter hours. In relational system I'd have two tables "Clients" and "Hours" which would match on a foreign key.
How can I do things like this in notes? Does it take me two databases (one for clients, one for hours) or is it possible to have to tables of completely different types in one database.
Or do you enter all the information in one database and do the display via two different Notes-Views?
(btw. my notes-book will really be there in some days, then I'll stop asking those "silly" questions ;)