I barely do any Lotus Designer work, so please bear with me. I need to customize an existing view in a Sales Forecasting application. The current view is in the "opport.nsf" database, which has the details of each forecast entry. It's select statement is:
Problem is, I'm being asked to categorize the view by Industry (Commercial, Healthcare, etc..). Problem is, that information is kept in another database, "contact.nsf", where you'll find high level info on the company like address info. Each record in either db has a CompanyUnique field that is the unique identifier, which is how the app ties the info together.
Being VBA guy, I'm assuming it starts with a select statement to joing the two sides together, but no idea where to begin. Any guidance would be appreciated... Thanks!
Code:
varSuccess := "0";
varFail := "-1";
SELECT (Form = "opp" & @IsNotMember (Status ; @Trim (varSuccess : varFail)))Problem is, I'm being asked to categorize the view by Industry (Commercial, Healthcare, etc..). Problem is, that information is kept in another database, "contact.nsf", where you'll find high level info on the company like address info. Each record in either db has a CompanyUnique field that is the unique identifier, which is how the app ties the info together.
Being VBA guy, I'm assuming it starts with a select statement to joing the two sides together, but no idea where to begin. Any guidance would be appreciated... Thanks!