I agree with Peterson. You need an Assembly table that has a field FrontOrRear that has a domain of (‘F’) or (‘R’). You will want to break up the Assembly object the way you would break up the Product object – into a main table with universal properties then you will have subtables that special properties. The FrontOrRear field will most likely be in a subtable.