Stuck with DLOOKUP() criteria

[MikeB]

I just can't wrap my mind around this.

I'm helping a friend create an Access DB to store information about
her jewelry designs. She uses metal rings to make chainmaille weave
design jewelry.

Each design can have one or more patterns. Each pattern has a weave id
(ring gauge, ring diameter and weave pattern) and can be in any of the
metals she works with, ddepending on the type of metal, the same weave
pattern can take different times.

So I have a table of Weaves: ID, WeaveName, Material, Gauge,
Diameter, RingsPerInch, and TimePerInch

I'm now trying to create a table Components, to list the set of Weave
patterns that makes up a single piece.

Components: ID, ItemID (FK to the piece), WeaveID (FK to Weave),
Quantity, and Length.

I want a form to display the details of the component (and the item
(or piece).

In my form I need to have a field (control) that displays the material
that is used in that particular weave.

I can get =DLOOKUP("[Material]", "[MaterialList]") to obtain the first
record in the material table. However, I cannot figure out the
criteria to backtrack from the Component record's WeaveID field to the
Material field in the Weave record that has the FK for the actual
Material.

Is this even possible or should I try and figure out an alternate
approach?

Thanks