Screen Question

[adewitt]

I have a screen that has 3 mv columns
Column1     Column2     Column3
xxxxx          xxxxxx       xxxxx
xxxxx          xxxxxx       xxxxx

Currently they are each controlling fields.

I need to change it to have 6 mv columns:
Column1 Column2 Column3 Column4 Column5 Column6
xxxxx      xxx       xxxxxx    xxx       xxxxx      xxx
xxxxx      xxx       xxxxxx    xxx       xxxxx      xxx

The presentation order is Column<1,1> Column<2,1>
                                  Column(1,2> Column<2,1>

etc..  When I encounter a null value in Column1 then I jump to Column4 and the order is
                                    Column<3,1> Column<4,1>
                                    Column<3,2> Column<4,2>

Given the limitations of System Builder is what I want to do possible is there a better (easier) way to accomplish what I want.  I should note that there is some validation that needs to take place when entering value data in Columns 2, 4 and 6.

Hope this makes sense.

 

[precisonline]

I'm interpreting a little, but wouldn't it be possible to setup columns 1, 3, and 5 as controlling and the others as dependent.  If the fields are in order that should do what you want, won't it?

[adewitt]

I'm interpreting a little, but wouldn't it be possible to setup columns 1, 3, and 5 as controlling and the others as dependent.  If the fields are in order that should do what you want, won't it?

I thought you could only have one Controlling field per screen.  I guess I'm wrong which is why I'm glad to know people who have a lot more experience than I do.  Here is my screen:
   ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄSTYLMARK PRODUCT WARRANTY MAINTENANCEÄÄÄÄÄ¿   
   ³ Empl Nbr  585   ALBERT DEWITT                                                           ³   
   ³                                                                                                      ³   
   ³ WO Nbr    525804     SO/Line   663629*001   FAUBION ASSOCIATES INC     ³   
   ³                                                                                                       ³   
   ³ WO Qty    1          S/N Count 2            Complete Y                                 ³   
   ³                                                                                                       ³   
   ³ S/N       1500390                                                                               ³   
   ³                                                                                                       ³   
   ³ P/N   580759-03                   580758-03                                               ³   
   ³ DESC  MIG12 DELUXE 4100K    MIG6 DELUXE 4100K                                  ³   
   ³ QTY            4                                     1                                            ³   
   ³       04100802360 ____           041008050115 ____                                 ³   
   ³       04100802254 ____                                                                       ³   
   ³       04100803133 ____                                                                       ³   
   ³       04100803191 ____                                                                       ³   
   ³                                                                                                       ³   
   ³                                                                                                       ³   
   ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ

The underscores show where the dependend field is.  When I begin on 04100802360 and press enter I go to the first dependent field.  When I press enter I go to 04100802254.  The next Enter goes to the second dependent field and so on until I reach 04100803191.  When I press enter I do not go to the dependent field, but I go 041005050115.  When I press enter there I do not go to the dependent field but I go to the next field after that which is Complete.

Is this because I'm testing on an existing record?  This could get tricky as we are using a bar-code scanner to enter these numbers.  The scan sends a CHAR(13) at the end of the scan.

Thanks.

[precisonline]

Is this because I'm testing on an existing record?

Nah; simply change the Control/Dep/Read on the 3rd and 5th fields to C instead of D.  That should do the trick.

This could get tricky as we are using a bar-code scanner to enter these numbers.  The scan sends a CHAR(13) at the end of the scan.

Actually, not tricky at all; that's EXACTLY what you want the scanner to send.  That'll move the cursor to the next prompt in the sequence.  Get the cmv's and dmv's setup the way you need and you should be golden.

I thought you could only have one Controlling field per screen.

You can have any number of controlling mv's per screen; only one controlling mv per mv "set", but as many as you want per screen.