Quick question

[Michael Lee]

Hi Anthony,

Have your table occurring as many times as necessary and create the cluster with the
function code and rate fields. Place the project number field above the cluster and add the
following item statement (I'll include snippets of the other code):

     ITEM PROJECT_NUMBER FINAL FIRST(PROJECT_NUMBER OF table)

FIELD PROJECT_NUMBER of TABLE

ALIGN (1,,4) (,,20)
CLUSTER OCCURS WITH table
FIELD FUNCTION_CODE OF table
FIELD RATE of TABLE
CLUSTER


Good luck.


Michael Lee
MCL Systems Inc.


"Arnone, Anthony" wrote:

> 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.