Multiple links

[Bruce Rodtnick]

Let me try this again.

I have three tables:
VETERANS - Contains records of WWII veterans
TAPES - The tapes we've used to record the veterans
CLIPS - Individual soundbites from the tapes

Each veteran has a least one tape.
Each tape has numerous clips.

BUT each tape can contain more than one veteran.

My problem lies on how to link one veteran with more than one tape AND
one tape with more than one veteran.

Can you help me?

Bruce Rodtnick

 

[Kelvin]

What do you mean by link? Are you refering to a form/subform or do you mean
the relationship. If its a relationship, its called a many-to-many. You
can specify this in the relationship window. If its on a form/subform, just
set the parent/child link depending on way your form is set up. I will need
more details to be spcific.

Kelvin