tracking

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

I have a access database set up to track "events" and this goes back to the
original ID. I want to be able to split the "event" to 2 or more different
pathways but still be able to see the original "events". Do I need to create
an additional ID.
Thanks
 
It sounds like a relationship to me. One 'event' can have more than one
'pathway'. In that case, EventID would be unique to the event, regardless of
pathway, and in a child table 'pathwayID' would track individual pathways,
with a foreign(parent) ID to tie it to the original event.

It may not fit the 'standard' bill for creating a relationship between
tables, but in all reality, it is the only effective way to get one item to
do two different things.

hth

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill
 
Back
Top