How do you want that code to look?
Using the above example, do you want:
or some other format?
Here's how to get the first version:
StyleNo & Substitute ( List ( Fabric Code ) ; ¶ ; "" )
And I'd probably use a related table of Fabric codes instead of the repeating field for better flexibility in working with this data. (List works much the same with a related table of records as it does with a repeating field.)
Thank you, Phil,
Well, I'd like to achieve:
Basically, beside of what I posted earlier, I am trying to build a 'SPECIFICATION DATA' for each unique garment product (record) per Fabric, per colourway, per style.
For an instance, a 2 button poloshirt style coded POLO1 is available in 2 different fabric
- one is stripe (ST001), available in 2 colours: black & white stripe (col.79) / pink & green strype (col.35)
- the other one is plain soild colou (PL022), available in 2 colours: Pink solid colour (col 25) / White solid colour (col 01).
At the same time, other styles are available in these fabric / colours (ie: regular t-hsirts and long sleeve t-shirts etc..)
For the POLO1 style, to specify the buttons for this specific style (Style + Fabric Code + Colour Code), I am struggling the best method to create the true vale / information.
Styles contain the image of style and style no.
Fabric contains fabric codes and supplier / composition info
Colour contains colour codes, Fabric codes, colour names.
Specification contains all above including Fabric Code.
What's the best way to link the Specification with ALL BOVE...
Thank you if anyone can give me advice.
I'd use related records of this information. Then, via the relationship, the same parent record can supply the same style code to each.
In manufacturing, it's typical to set up these relationships:
ProductSpecs----<BillOfMaterials>------MaterialSpecs (---< means "one to many")
The related BillofMaterials table, lists each type of material as well as quantiites needed to produce one Instance of the specified product. It functions as a join table as a given material might be used in the manufacture of any number of different products. In your case it would look like you need this structure: