Good Morning/Afternoon/Evening
Just a quick question guys, i know your the guru’s at Lotus Approach, i probially have posted this in the wrong section, if so can someone move it please
My question is, i’ve made a small database contining 1500ish people. anyway i need this to be relational. and i cant find anywhere that i can make it relational. ive made join’s between the databases. but when i do, it just makes another company when i add another customer… i’m just STUCK 
I have been working on this for just over a week and dont know where to go from there.
is there any books i can buy or can i visit someone’s website and get them to make it for me
Thanks in advanced
Daniel.
Subject: Lotus Approach
Notes/Domino is NOT a relational database - If You want to mimic relational behaviour - then You have to manually program the functions using LotusScript or @Formulas.
It is not easy - and something I wouldn’t recommend for a beginner. There is a lot to think about trying to do that.
Think of Notesdocuments as papers in a binder/folder - each paper/document is a separate container of information and has no automatic relation to another. If a relation must be specified - then You must save a field in the document containing information about what it is related to.
You DO have something that also can be used in mimic relationship databases: Response and Response-to-response documents. Read more about this in Designer Help.
hth
Subject: RE: Lotus Approach
Thanks for the reply.
Subject: There are a few sample databases that come with Approach that contain relational applications
Contact Manager SmartMasterEmployees and Departments
Customer Call Tracking
Open those up and look at their designs, they will show you how the relational databases are created in Approach. Most likely you are not setting the key properly or something or you are not setting the primary database.You should also check out the SmartSuite forum, lots of knowledgable folks there on Approach.
Subject: Lotus Approach
You’re right, this is not the correct website for Lotus Approach. Anyway you should get a book from eBAY.
However, if you wish to do this using Lotus Notes/Domino, Release 8, does allow you to do you relational data modelling in DB2 and then it is possible for Lotues Notes/Domino to connect to DB2 to do enquiries and updates.
Subject: RE: Lotus Approach
Thank you for your quick responce, will try.
Daniel.