Reply-To: "Eric Theil" From: "Eric Theil" Newsgroups: comp.databases.theory References: <3cceb672$1@mindmeld.idcomm.com> Subject: Re: Archival or Snapshot data (database design) Date: Thu, 2 May 2002 08:44:07 -0600 Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 216.98.199.32 X-Original-NNTP-Posting-Host: 216.98.199.32 Message-ID: <3cd15065$1@mindmeld.idcomm.com> X-Trace: 2 May 2002 08:42:45 -0700, 216.98.199.32 Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!dimensional.com!pulsar.dimensional.com!207.40.197.76.MISMATCH!mindmeld.idcomm.com Xref: easynews comp.databases.theory:20622 X-Received-Date: Thu, 02 May 2002 07:40:33 MST (news.easynews.com) I'm not sure what you mean. Do you mean the order of the create table statements? I messed that up. If I take those statements and rearrange them by creating the event table last (since it tries to reference the employee and venue tables before they are created) I get the relationships I need. Anyway, I'm not so concerned about creating the relationships as I am with coming with a way to enforce the integrity of the data without creating straight foreign key relationships. As an example, If I create a record in the Event table and then The Name column within the Venue table is changed, I don't want that to be reflected when pulling information about the event. I'd be doing a join across those two tables and pulling the new name of the venue. I want to come up with a way of tracking history to changes within the foreign key tables (venue and employee) so I know the names of employees and venues as they where when the Event record was originally created. e "Steven Hauser" wrote in message news:aarflq$meb$1@garnet.tc.umn.edu... > Your event table is not connected to the two other tables by your own > definition. >