'Either Or' instead of 'And'

[Mariusv.Z]

Hi. I'm new here.

 

I have:

 

table: Products

field: Product ID

field: Fabric (Drop down box populated with lookup from field: FabricID from table: Fabrics)

 

table: Fabrics

field: FabricID

field: Products that use this Fabric (Portal that displays field: Product ID's based on relationship check Fabric = FabricID)

 

Swell. Works ok.

 

Problem is some products can use more than one fabric.

 

So I set up in table: Products field: Fabric2 (same lookup of FabricID) and add Fabric2 = FabricID to the relationship.

 

This doesn't work obviously, because the relationship now needs both Fabric and Fabric2 satisfied to display the ProductID.

 

Is there a way to base the relationship on 'Either' instead of 'And', or some other way to do this?

 

Thanks in advance!

 

 

[bcooney]

You need a join table Products>ProdFabrics<Fabrics.

 

Each record in the join table would store the unique combo of Product and Fabric to resolve what is called a many-to-many relationship.

[Mariusv.Z]

Thank you very much.