durban1

New guy (still). I would like to create drop down fields for, say colors. There are 3 colors; red, white and blue which I presume I will store in a value list. Ok, let's say there are 5 sizes: S,M,L,XL, and XXL, also in a drop down field. Red only comes in M and XL, so when I select Red in the first drop down list (in browse mode), the only sizes I want to see in the Size field are the ones exclusive to Red (M and XL). I should be able to choose either of those sizes, but I don't even want to SEE the other sizes. Maybe this isn't the easiest way to do this, but this is basically what I want to accomplish. When one parameter is selected, the next selection will only have those options that are available as options. And of course, after these two options are made, there may be more...red in a medium may only come with blue stripes...you get the idea. Thanks to all.

Thanks again for your patience and prompt replys. I unzipped the file per your directions and it looks like this will be very much in line with what I can use. A couple of questions. In the size field, how can I change the format from "S,M,L,XL" you used to actual dimensions, such as "38.75 x 99". I'm sure it is simple but I can't figure it out. Also, will that affect related fields. Also, can I change indexed fields to popup fields (as the occasional field has many choices) and will that affect the way the fields relate. I have sent for a manual, and I'm sure it will all come together over time, but it is all brand new to me. Finally, in the price list, for instance, can I insert another parameter, if needed, and will THAT affect relations. Thanks again for your help.

Thanks to all for your excellent help. Unfortunately the file you attached is "unmodifiable". Is there another way to send it?

Thanks for your quick response...I think what you posted will help and I will also research the "lookup" in someone else's comment. Would it be difficult for you to post an example of that? Thanks again, durban1

Novice user. Trying to write what is probably a basic script, but I am sooooooo confused. What I would like to do is return a price in a separate field (in the same layout, for now) when conditions are satisfied in two popup fields. These are both text fields, colors in one, sizes in the other(such as 38x97.5). Can someone help me out with a sample, or point me to the best help site for a beginner? Thanks very much