June 6, 200916 yr Greetings, I have a section on the Database that i am building, it is going to be used for the Attribs. There is actually 3 tables involved, * Attribs Controler * Attribs Value * Attribs Type Attribs Type: The idea of this table is that it allows for you to enter the type for in this case; * Colour * Size Attribs Value: This table actually holds the values of the Types, so for example; Colour Black Colour Red Attribs Controller: This is just holds the values entered for each of the products. [color:blue]Tables Attrib Controller: Attrib_ID Attrib_SortID Attrib_TypeID Attrib_TypeValue Attrib_ValueID Attrib_ValueValue Product_ID Attrib Type: Attrib_ID Attrib_SortID Attrib_Type Attrib Value: Attrib_ID Attrib_SortID Attrib_Type Attrib_Type_ID Attrib_Value [color:red]Relationships Attrib Controller:Attrib_TypeID = Attrib Type: Attrib_ID Attrib Controller:Attrib_TypeID = Attrib Value: Attrib_ID Attrib Value:Attrib_Type = Attrib Type2: Attrib_Type [color:orange]The Field Setup Attribs Controller: Attrib_TypeValue = Drop down list, using values from the field Attrib Type:Attrib_Type Attribs Controller: Attrib_ValueValue = Drop down list, using values from the field Attrib Value:Attrib_Value; Include only related values starting from: Attrib Type 2. [color:brown]The Problem When i select a Type IE: Colour and goto select black from the drop down list, there are no values in the list, they are not showing up. Anyone have any suggestions, Thanks (In Advanced)
June 20, 200916 yr If I follow this correctly (I am not sure what exactly your field names represent), your relationships should be: Attrib Controller::Attrib_TypeID = Attrib Type::Attrib_Type_ID Attrib Type::Attrib_Type_ID = Attrib Value::Attrib_Type_ID and the second value list should show values from Attrib Value::Attrib_Value, include only related values starting from Attrib Type. This is not the only possible arrangement, but it seems the most sensible to me.
July 5, 200916 yr Author Greetings, Thanks for replying... I tried that and it didnt work, i actually tried it the first time but just incase there was something i did wrong, i deleted the realationship and tried it again. Still didnt work.
Create an account or sign in to comment