Qdesign question -- Multiple fields occupying the same locati on.

Robert Mills robert.mills@windsong-services.co.uk
Mon, 12 Jun 2000 12:32:43 +0100


Thanks Dave. Just what the doctor ordered.

-----Original Message-----
From: Knox, Dave (Dallas, TX) [mailto:knoxda01@unisourcelink.com]
Sent: Friday, June 09, 2000 6:39 PM
To: 'PowerHouse ListServer'; 'Robert Mills'
Subject: RE: Qdesign question -- Multiple fields occupying the same
locati on.


Robert

Try this...

Hide the redefines...display the original, note the output procedures at the
end.

field FIELD-1	;etc...

hilite display off

;define the redefined fields somewhere obscure - they won't be seen
; set the selectbox at the same place for each...

field FIELD-2-R1 id same nolabel required if FIELD1 = "A" selectbox on
data;etc...
field FIELD-2-R2 id same nolabel required if FIELD1 = "B" selectbox on
data;etc...
field FIELD-2-R3 id same nolabel required if FIELD1 = "C" selectbox on
data;etc...
field FIELD-2-R4 id same nolabel required if FIELD1 = "D" selectbox on
data;etc...

hilite display default

field FIELD-2 display ; placed after redefs so will display result from
above.

;don't want to see the redef'd fields....so...

procedure output FIELD-2-R1
   let fieldtext = ""
procedure output FIELD-2-R2
   let fieldtext = ""
procedure output FIELD-2-R3
   let fieldtext = ""
procedure output FIELD-2-R4
   let fieldtext = ""


> ----------
> From: 	Robert Mills[SMTP:robert.mills@windsong-services.co.uk]
> Sent: 	Friday, June 09, 2000 11:48 AM
> To: 	'PowerHouse ListServer'
> Subject: 	Qdesign question -- Multiple fields occupying the same
> location.
> 
> Hi all,
> 
> Thought that I would throw out a question as it was so quiet on the list
> today ;).
> 
> I have two character*1 fields defined in the PHD with value and caption
> strings. The field-1 has 4 pairs of entries and the field-2 has 11 pairs
> of
> entries. On my screen I have used the SelectBox option on the Field
> statement so that the user can choose from a list of available options.
> 
> The value selected on field-1 should control what is displayed in field-2.
> 
> For example:
> 
>   field-1 has the values A, B, C, and D.
>   field-2 has the values 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and 11.
> 
>   Selecting A should only display 1, 2, 3 and 11, B should only display 1,
> 4, 5, and 9, etc.
> 
> My attempt to resolve this was to redefine field-2 in the PHD several
> times.
> Each of the redefining fields had its own value and caption strings. I
> then
> added the redefining fields to the program in place of the original
> field-2.
> An IF 'field-1' = "x"' option was added to each of the redefining fields
> to
> force the correct field to be prompted for. See example:
> 
> Field field-1                Id At , 52                            &
>                              Label "Type" At , 55                  &
>                              Data At , 60                          &
>                              SelectBox From , 60                   &
>                              Required
> 
> Title "Mode"                 At , 62
> 
> Field field-2-r1             Id Same                               &
>                              NoLabel                               &
>                              Data At , 67                          &
>                              SelectBox From , 20                   &
>                              Required                              &
>                              If field-1 = "A"
> Field field-2-r2             Id Same                               &
>                              NoLabel                               &
>                              Data At , 68                          &
>                              SelectBox From , 20                   &
>                              Required                              &
>                              If field-1 = "B"
> Field field-2-r3             Id Same                               &
>                              NoLabel                               &
>                              Data At , 69                          &
>                              SelectBox From , 20                   &
>                              Required                              &
>                              If field-1 = "C"
> Field field-2-r4             Id Same                               &
>                              NoLabel                               &
>                              Data At , 70                          &
>                              SelectBox From , 20                   &
>                              Required                              &
>                              If field-1 = "D" 
> 
> It works ... BUT it looks amateurish. Not something that I would like to
> give the users. As you can see, the data for the redefined field-2's take
> up
> four spaces on the screen. This is because Qdesign objects if you overlap
> existing fields. What I would like is to be able to have the 'Mode' data
> one
> space after its label whichever field-2-rN was used.
> 
> Any ideas??
> 
> Regards,
> 
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> +
> |Robert W.Mills (Senior Analyst/Programmer) |    >>>> Please Note <<<<
> |
> |Windsong Services, St. Mary Cray, ENGLAND  |The opinions expressed above
> |
> |Tel  : +44 (0)1689 870622 x3005            |are my very own and NOT
> those|
> |Fax  : +44 (0)1689 899026                  |of my employer. They are
> thus|
> |Email: Robert.Mills@windsong-services.co.uk|subject to change or
> complete|
> |URL  : www.windsong.co.uk                  |reversal without any notice.
> |
> +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
> +
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.