0 Replies Latest reply on Sep 12, 2013 7:33 AM by Kirk_1

    How would you design this layout?

    Kirk_1

      Title

      How would you design this layout?

      Post

           I need to build a layout and put a % in each field...that represents an entry  from every state to every state... Ex. From AK to AK, AL, AR, AZ... then Al to AK, AL, AR, AZ... there is a potential of 2500 entries.

           I have it broken into regions now:

                      West = 11 western states.. I have one entry for a field called west to west,  not 121 entries.

                      Midwest = 18 mid-western states...  West to Midwest is one entry (the field is called Midwest to west )  not 198 entries.

           I use the following script to determine the assignment of a state into a region.

           Case (

                           PatternCount ( "AZ CA CO ID MT NV NM OR UT WA WY"; Invoice::INConsigneeState); "~W";

                           PatternCount ( "IL IN IA KY MI OH WV WI AR KS LA MO OK TX MN NE ND SD " ; Invoice::INConsigneeState) ; "~MW";

                           PatternCount ( "CT DE DC ME MD MA MS NH NJ NY PA RI VT AL FL GA MS NC SC TN VA" ; Invoice::INConsigneeState ) ; "~E" ;

                        )

           This Ex above is for one customer and one vendor for that customer... each customer has 2-7 vendors, so i need a record for each customer and its subsequent vendors.

           To top it off, i need a % that represents the vendors % to me and another one from me to my customer.

           Ive uploaded an example of the way i have it broken into regions now, the far right side is cut off but you can see what i've done.

            

      Capture.PNG