[thelist] ASP logic problem - deleting record

Chris at globet.com Chris at globet.com
Thu Dec 29 11:21:15 CST 2005



> Perhaps I shouldn't have normalized the database and instead 
> should have left the date as a field in the event table. It 
> would have made deleting/editing the records a hell of a lot 
> easier! However, with the date in a separate table, I only 
> have to edit one of the committee events once to have it 
> apply to all dates.

Could you keep the date in the event table, and instead of having a
table for dates: have a table for event types. In the events table you
would store an event type ID instead of a text description for each
event. This event type ID would refer to an event type record in the
event types table, the editing of which would reflect your changes
across all events of this type.

Chris Marsh
Web Developer
Tel: +44 20 8246 4804 Ext 828
Fax: +44 20 8246 4808

Any opinions expressed in this email are those of the individual and not
necessarily the Company. This message is intended for the use of the
individual or entity to which it is addressed and may contain
information that is confidential and privileged and exempt from
disclosure under applicable law. If the reader of this message is not
the intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please contact the
sender immediately and delete it from your system. 

More information about the thelist mailing list