field association

[misschanda via AccessMonster.com]

hello,
i have this form, that has four possible experiments per record per project
number. Each experiment has a main resin and 3 additives or 4 ingredients,
therefore possible of 16 ingredients. conversely, each ingredient is
associated with a entered supplier, therefore 16 suppliers,

I am trying to design the query so that when a a certain supplier is searched
throughout table

i will be able to formulate a report as follows:

supplier name

materials from particular supplier (from any ingredients)

project number each material is linked to.

Futhermore, if that ingredient was used as a resin a check will appear under
column main resin or etc.

how do you advise this.

currently i have;
SELECT TBLLABLINE.[Trial Number], TBLLABLINE.[Project Number], TBLLABLINE.
SupplierB, TBLLABLINE.SupplierC, TBLLABLINE.SupplierD, TBLLABLINE.SupplierA,
*
FROM TBLLABLINE
WHERE (((TBLLABLINE.SupplierA) Like "*" & [forms]![lablineextrusion1]!
[text515] & "*")) OR (((TBLLABLINE.SupplierB) Like "*" & [forms]!
[lablineextrusion1]![text515] & "*")) OR (((TBLLABLINE.SupplierC) Like "*" &
[forms]![lablineextrusion1]![text515] & "*")) OR (((TBLLABLINE.SupplierD)
Like "*" & [forms]![lablineextrusion1]![text515] & "*"));


thanks \
la