creating different size scale
Hi i have a PO for clothing. there are two size runs. one for men (S,M,L,XL,2XL,3XL)and one for women (XS,S,M,L,XL).
instead of having both just listed on the PO with another field indicating which is which, i want to create a field on the record where if it is blank (default) the rows will real the men's scale. if there is a "A" in the box, then it will change to the women's scale.
when i open a new record it will be defaulted as men size unless i add the A
i tried creating script and it sorta works. when the field "size run" is blank, and i hit a button, the 6 fields (Size1 1 -6) fills with the 6 men's sizes. when i put an A in the "size run" field and hit the button, it changes to the women's scale. however when i change records the next record reads what the last one read.
how do i fix this.
see script attatched.