Multi value field question

[BBD]

HI
I am a novice who has made only a couple of databases, and never used multi value fields.

We sell canvas art and some products may use more than one frame panel.

So what I want to do is in the first column have the unique id of a product layout
EG:
Sg11-A (single 1 by 1 ratio A size)
TR11-A (treble 1 by 1 ratio A size)

In the second column I want to specify the frames I would use so
|STYLE|FRAMES|
|SG11-A|30x30|
|TR11-A|30x10,30x10,30x10|

So the Tr11-A has 3 frames and SG11-A has 1 frame

Hope that makes sense.

Later after sussing this, I would connect a sales table via the STYLE, and should be able to count used frames if I am not mistaken.

First issue I see, is duplicate values in a multi field ?

Any help or direction appreciated.

[June7]

Input to a multi-value field would likely be via a multi-select combobox or listbox. This should not allow duplicates of a value.

However, I do not recommend use of multi-value field at all. A normalized structure would be a dependent child table where each item is a record with fields for FrameType and Quantity and StyleID.

[Steve R Jones]

June7 - Thanks for stopping by and lending a hand.