Defining data by using product material

[jbayness]

Good morning all. My first post here with very limited FM experience. apologies in advance...

Here is what I am trying to do:

I am trying to create a quote form for my users. The form has a radio button for product material (containing two options; paper or plastic). This is basically the key to the form and where my problems have started. What I want to have happen is pretty simple i think. When a user selects one of the two radio options, I would like the corresponding fields below (color, size, style, etc) to represent options that only apply to that material.

As far as table setups go, I have setup a table called ProductMaterial that consists of two fields - MaterialID and MaterialDescription. I also have tables setup for the other fields (Size, Color, Style, etc) that include a MaterialID field. I have setup relationships between the Material Table and the other tables based upon the MaterialID field that is located in each table.

So now I go back to my original question. On the form, I have setup the fields to lookup to their respective tables, but I am missing something that links the radio button selection to the drop down choices.

For some example data, this is how it would work:

If a user started by selecting a plastic product on the radio, the color options would read red, white or blue, and the weight options would be 5 or 10. A paper selection from the radio would have black and green with weight options of 1 or 2.

Hopefully all of this makes sense. Thanks in advance.

[aldipalo]

I believe what you want is a conditional value list. Take a look at the attached file. I hope this gives you some initial direction.

BTW, in looking at my app I guess I could just as easily have had 1 table for both color and weight. Your choice.

CVL_Test.zip

CVL_Test.zip

[mr_vodka]

Hi JBayness,

What you are looking for is conditional value lists. There are many posts on here regarding teh subject as well as samples. Also, take a look here for an example. Ray's Demo

[jbayness]

Yea, I am officially an idiot - I had everything linked to the master materialID - not the fk_MaterialID. I will play with this for a while. Thanks so much!

[aldipalo]

No such thing as an idiot. If that were so I'd have to include myself in the class. My motto is "I may not always be right, but, I AM NEVER WRONG!" So in this case you just weren't right. ;)

[jbayness]

Ok another random question kinda pertaining to the original question...

I have gone through and got everything working. I also added some CVL's to some user information (I.e. name, phone, fax, email, etc which is stored in a different table). This all works fine as I can choose a user and all of their information will show correctly in the corresponding fields. Perhaps I am being nit picky, but i would like to speed up the process of data entry here. Currently they have to go to each field and select the one line of data that is there from the drop down box. Is there a way I can get this information to automatically fill in instead of having the user tab to the field, hit the down arrow and tab off it?

thanks again for everyone patience.

edit: my apologies - i meant to add this as a reply to the following topic: http://fmforums.com/forum/showtopic.php?fid/32/tid/183907/pid/237194/post/last/#LAST

Edited January 27, 2007 by Guest

[aldipalo]

It sounds as though you are trying to use a valuelist where you don't need to. If your relationship is set properly when you enter the Contact_ID (Whatever unique value you are using) the rest of the data from that table should also appear. Make sure the fields LIKE :Name, ::Address, ::City, ::State, etc. are from the Contact table.

ContactTable::Name, ContactTable::Address, ContactTable::City, ContactTable::State.

If the data doesn't show check your relationships.

HTH

[jbayness]

hmm - I will look at this. Thanks for the post.

[jbayness]

Yea, I refer back to my other post where I stated I was an idiot... That fixed my problems... Thanks aldipalo.

[aldipalo]

Glad I could help! It is payback for all the great help I have gotten in the past and continue to receive.

Al