Attribs for Products

[Delights]

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)

[Delights]

Anyone have any ideas ?

[comment]

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.

[Delights]

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.

[comment]

It works for me.

ObjectAttributes.fp7.zip