Link 2 Lotus forms to present data of only one

[testor15]

As a newbie Lotus data miner, when I asked a question yesterday and had a great response, I wanted to present this idea / question. ( http://planetlotus.org/forum/index.php/topic,4509.0.html ).

How do I do a two form join in Lotus Notes Designer into one view? Syntax for an inner join?

My project needs to take the data segregated in form1 'Proj' and link it back to the other form2 "Summary' then present only the linked form2 data.  Each form has a linking field called 'RecordID'.

What I would like to do is have the view open with the code in the 'view selection' as my previous query does.  In other words, if I have this query "  SELECT ((Form = "Proj") & CreateDate > [09/25/2009])  " finding the search data, I want the field 'RecordID' go to form2 'Summary' and find intersecting results for view 'ProjSummary'.

  In other words I want the data from Form ProjSummary:
            SELECT (Form = "ProjSummary") & (Form = "Proj"  & CreateDate > [09/25/2009])
            where ProjSummary.RecordID = Proj.RecordID

I hope this makes sense.  I have been researching this via the web without success.  Being a Lotus newbie makes it harder when you are under a time constraint.

Thanks!

[CurtStone]

Your thinking Lotus Notes is a relational database and it isn't.  I know, that's difficult to understand at first.  My thought is that you have to either inherit form1 values into form2 at the time form2(check out the form property on form2 for this) is created or you need to run LotusScript code either by agent or maybe on the querysave of your form2 to grab the form1 data via the related id.

[testor15]

The simplicity and clarity of your answer has caused me to return to my project and look for another way to finish my project.

Thank you for your assistance.

[CurtStone]

Sounds good.  That's the kind of answer I was trying to give, a simple one.  It's interesting how we often look for a complicated solution even though simple solutions exist.  Good luck.