problem with name

  1.  
    1. the name field in a lego element is not unique, the element id is. unfortunately this database system autofills based on the name field, which is a pain as there are many bricks (different colours) with the same name. that means you have to create a new item entry for each name even though it is the same - ie.

      brick 2x4 design id 3001 element id 300101 colour white

      brick 2x4 design id 3001 element id 300121 colour red

      is there a way to get it to use the element id as the index, not the name?

      it would save allot of time in data entry

      1. Perhaps the name of the lego element could be the element id, and the disambiguating information could be the brick style (e.g. 2 x 4), design id and color?

      2. Sorry, I've still been trying to figure out the best way to model this, but you're right. How about this:

        • The name property on Element Design should be the style description (i.e. brick 2x4)
        • The Design ID property should be the design id (i.e. 3001)
        • The name property on Element should be the Element ID (i.e. 300101)
        • The Element ID property should be scrapped.

    Discussion is posted in:

    Think this discussion also relates to something else? Cross-post it by adding a new discussion area:

Search Discussions

Related Discussions