in access i am trying to sort a load of photos into multiple catagories 

if one customer is female, age 30-40, is tall, has Course hair, but not alot 
of hair on there head ect ect. this photo may belong to ages 20-30 as well as 
30-40 and may be sutable for someone with fine hair aswell but maynot suit 
someone with thick covering of hair. i would like this database to tell me 
all picks that will suit this customer and others.
what tables should i create and how should i relate them.

if anyone can help great

On Mon, 1 Feb 2010 03:04:01 -0800, Ahhmonkey
<Ahhmonkey@discussions.microsoft.com> wrote:

Let's formalize your language a bit:
Each photo has multiple characteristics.
Each characteristic can occur on multiple photos.
That's a classic many-to-many relation. In Access you express that
with a junction table between Photos and Characteristics:
tblPhotosWithCharacteristics
PhotoID
CharacteristicsID
and you create the primary key over both fields.
Then in the Relationships window you draw lines between the
corresponding fields in these 3 tables, and check the box to enforce
them.

-Tom.
Microsoft Access MVP



>in access i am trying to sort a load of photos into multiple catagories 
>
>if one customer is female, age 30-40, is tall, has Course hair, but not alot 
>of hair on there head ect ect. this photo may belong to ages 20-30 as well as 
>30-40 and may be sutable for someone with fine hair aswell but maynot suit 
>someone with thick covering of hair. i would like this database to tell me 
>all picks that will suit this customer and others.
>what tables should i create and how should i relate them.
>
>if anyone can help great