Hi all,

I am now trying to do a conditional value list for my product catalog. I have a table called measurement standards so you can switch between metric and US standards and i want to create a conditional value list based off which is selected with my packaging table.

Now i have tried to disect every ******* demonstration file on here and I have watched John Mark Osbornes Videos over and over and iam just not getting it.

I want to know why people are using global fields and what are they doing?

I would like to know how table occurances relate to the global fields and finally i would like someone to explain to me if the join table i have created is overkill and how do i create a conditional packaging valuelist based off the measurement standards valuelist. Do i need the join table? How many global fields do i need and Table Occurances?

If you could look over what i have thus far and mb point me in the right direction as far as relational theory and since i am desperate could you show me in my example how to set up the conditional valuelist i talked about above.

I have spent 4 12 hour days trying to get a grasp on this.

I figured i could create a calculation field to do what i want without the relationships. Am I wrong thinking this? I just create 2 value lists

american_packaging

metric_packaging

My guess would be:

case( measurement_standard=1;valuelistitem(get(field);"american_packaging"; measurement_standard=2;valuelistitem(get(field);"metric_packaging"

but i tried it and its not working.

AHHHHH what is wrong with me....

please help :jaw:

products.fp7.zip

Take a look at this version of your file. I added a new field "gStandard" that you fill in with either "Metric" or "American" and do the join on that. I added a new copy of "Packaging" table to your graph to do the join to, and made a relational value list similiar to the ones you defined.

Hope this helps.

products.zip

wow! I just figured it out today and now i see how you did it. I think i did it a little differently. Is the way i am doing it alright or should i stick with the extra table occurance and global field you have?

I have attached the file to show you how i did it.

Thank you so much. It so nice of people to take the time and help us ignoramous out

Carlisle

products.fp7_2.zip