Screen Question

Thu, 21 Aug 2003 14:09:26 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C3680F.5B726E50
Content-Type: text/plain;
	charset="iso-8859-1"

Can you not use a repeating PRIMARY where the Client code and Branch code
are outside of the CLUSTER. Then use the ITEM xxx FINAL FIRST(xxx) function
to get the Client and Branch code values into each record.

Bob Deskin              
Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: Arnone, Anthony [mailto:aarnone@grey.com]
Sent: Thursday, August 21, 2003 2:00 PM
To: Powerhouse List (E-mail)
Subject: Screen Question

All -

	I have a table that contains these fields:

Client Code
Branch Code
Rate Amount
Function Code

I need to create a screen that will allow the user to enter a client code
and a branch code once and then have an area to enter 15 function codes and
corresponding rate amounts. Then when the user is done and adds the record
it will write 15 separate records to the table with the different function
codes and rates but all will have the same client and branch code. If anyone
has any ideas I would appreciate it, I think my biggest problem is how to
write the record to the table. I am using version 8.19 on and HP3000 running
MPE/iX.
R/S 
Anthony Arnone 
Programmer/Analyst 
Grey Global Group 
(212) 886-7812 
aarnone@grey.com 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum.  Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details. 

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C3680F.5B726E50
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: Screen Question</TITLE>
</HEAD>
<BODY>

Can you not use a repeating PRIMARY where the Client =
code and Branch code are outside of the CLUSTER. Then use the ITEM xxx =
FINAL FIRST(xxx) function to get the Client and Branch code values into =
each record.

<P><FONT SIZE=3D2>Bob =
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>Product Manager, Application Development Tools, =
Cognos Inc.</FONT>
<BR><FONT SIZE=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: =
(613) 727-1178</FONT>
<BR><FONT SIZE=3D2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON =
K1G 4K9 CANADA</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Arnone, Anthony [<A =
HREF=3D"mailto:aarnone@grey.com">mailto:aarnone@grey.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, August 21, 2003 2:00 PM</FONT>
<BR><FONT SIZE=3D2>To: Powerhouse List (E-mail)</FONT>
<BR><FONT SIZE=3D2>Subject: Screen Question</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>All -</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>I have a =
table that contains these fields:</FONT>
</P>

<P><FONT SIZE=3D2>Client Code</FONT>
<BR><FONT SIZE=3D2>Branch Code</FONT>
<BR><FONT SIZE=3D2>Rate Amount</FONT>
<BR><FONT SIZE=3D2>Function Code</FONT>
</P>

I need to create a screen that will allow the user to =
enter a client code
 and a branch code once and then have an area to =
enter 15 function codes and
 corresponding rate amounts. Then when the user is =
done and adds the record
 it will write 15 separate records to the table with =
the different function
 codes and rates but all will have the same client =
and branch code. If anyone
 has any ideas I would appreciate it, I think my =
biggest problem is how to
 write the record to the table. I am using version =
8.19 on and HP3000 running
 MPE/iX.
 R/S 
 Anthony Arnone 
 Programmer/Analyst 
 Grey Global Group 
 (212) 886-7812 
 aarnone@grey.com

<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: &quot;subscribe&quot; in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: &quot;unsubscribe =
&lt;password&gt;&quot; in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>

Join us at Cognos' biggest event of the year =
Enterprise 2003, The Cognos Business Forum.&nbsp; Taking place in =
over 25 cities around the world, it's an opportunity for Business and =
IT leaders to learn about strategies for driving performance. Visit =
<A HREF=3D"http://www.cognos.com/enterprise03" =
TARGET=3D"_blank">http://www.cognos.com/enterprise03</A> for more =
details.

<P><FONT SIZE=3D2>This message may contain privileged and/or =
confidential information.&nbsp; If you have received this e-mail in =
error or are not the intended recipient, you may not use, copy, =
disseminate or distribute it; do not open any attachments, delete it =
immediately from your system and notify the sender promptly by e-mail =
that you have done so.&nbsp; Thank you.</FONT></P>

</BODY>
</HTML>
------_=_NextPart_001_01C3680F.5B726E50--