Relationship / value list help needed please

[vinniebigstick]

I think this is an easy one but i'm coming up short.  I attached a copy of my relationship chart

 

I have created a relationship for field "Lamp Type" between the  "Audit" and "Lamps" table.   I have a value list that to include all values from the "Lamp Type"

 

I've created value lists for fields "Number of Lamps", "Lamp Wattage" and "Ballast factor (lamp table)".   I've pulling those values from the "Lamps" table and have selected "related values only".   

 

What i'm looking to do is reduce the amount of values that are returned in those three fields to just what is selected from the previous.  

 

So for example - currently this works - 

 

First I would select my "Lamp Type" from all values on the "Lamps" table

 

Then I would select my "Number of Lamps" value which shows only the related info based on my selection of "Lamp Type"

 

Next however I want to select "Lamp Wattage" from a value list showing only the related items from records with the "Lamp Type" and "Number of Lamps" both matching.

 

and so on with "Ballast Factor" after that

 

How do I do this?

 

Thanks,

 

Vince

Audit Relationship.pdf

[IT_User]

Hello Vince,

 

I think you will have to create a couple more TOs (table occurrences) from "Lamps".

They would both be from the "Lamps" table, since that is where your field is.

The first having the relationship with "Number of Lamps" to "Number of Lamps".

Make a value list based on the new TO "Number of Lamps" with "Related Values Only" from the "Lamps" TO.

 

Do similar things for the others.

 

HTH (hope that helps)

Let me know if you have questions.

[vinniebigstick]

No luck...i've done as you have explained but now i'm getting just 1 option for each of the fields that are now referencing the new TO

 

I believe they are picking up just the 1st occurrence and not all the available based on the selections first chosen 

 

Any ideas?

[IT_User]

Sorry

Please see attached, and see if that helps.

valuelistTest.fmp12.zip