table problems

A

alex

I have been stuck on this for a few days now and its
really starting to bother me!

I have the following tables,
Issue, Owner, Area, Priority, Part, Supplier. I need to
relate these so that
One issue has one part - which can have many suppliers for
one part.
Each issue has only one area, priority, part, one owner
etc.
is it possible to have a function to clock repeating
issues?
the main problem is how to join these tables, and what, if
any new tables to add?(eg, joiner many-many tables)

Any help v.much apreciated

Alex Marchant
 
Top