Access photo sorting into multiple catagories

[Ahhmonkey]

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

 

[Tom van Stiphout]

On Mon, 1 Feb 2010 03:04:01 -0800, Ahhmonkey

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