Quick question

[Edis, Robert]

G'day Anthony

Create a temp item to hold the project id and put this near the top of the
screen.
Create a cluster to display the function code and enter/update the rate.

In the path procedure make sure the user is prompted for the project id in
the temp field and then use this to retrieve the records in the find
procedure.

Questions:

Do the records already exist but without the rate?
Is there actually two tables involved, one that stores the data you describe
and the other a lookup table that keeps a list of function codes?

If the latter then my logic above needs to be modified.

Regards,
Blue

-----Original Message-----
From: Arnone, Anthony [mailto:aarnone@grey.com]
Sent: Wednesday, May 07, 2003 8:39 AM
To: Powerhouse List (E-mail)
Subject: Quick question


Good morning all,

	I need some help creating a quick screen. I have a table that
contains 3 fields (project number, function code & rate) & what I need to do
is allow the user enter a project number and then enter rates for all of the
function codes that exist:

project number: 0zzzz

function code		rate

00LD						
0023  				                                 
0045				
0018				
00EF				

This is what I need the screen to look like which I can do, but my problem
is that when the user is done entering all the rates and updates I need to
create a record in the table for each function code:

project number	function code	rate
0zzzz		00LD		80
0zzzz		0023		10
0zzzz		0045		90
0zzzz		0018		75
0zzzz		00EF		100

This is where I am having a problem so if anyone has any ideas please let me
know. I am running ver. 8.19 on an HP3000 - 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.