RE: Event tracking design question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your help. I've read that book, it was good, but man its hard to
put that much work into a database before turning on the computer. I know
it's the best way to do it, but its hard.

Thanks for your help

Tom

mnature wrote:
I have a question. I was told that you shouldn't store information in a
linking table except keys, Is this true?

I prefer to call what I put into tables Data, and what I compile into forms
and reports Information. But that is partly just semantics. You certainly
should not store any calculated information in any table.

More to the point, in the book Database Design for Mere Mortals, Hernandez
states that "The linking table help to keep redundant data to an absolute
minimum." He then goes on to describe an OrderDetails linking table, which
links Orders and Products tables, and includes (other than the foreign keys),
the fields of Quantity Ordered and Quote Price. A linking table is exactly
where you would place any fields that refer to the record which is created by
the linking table.

In your database, a particular event that occurs in a particular venue, with
a particular contact person, would probably require a date to specify when
this unique occurrence is happening. That date cannot go anywhere else,
because it has no meaning except in the context of that particular record in
that table. It would have no meaning in any other table.

Again quoting Hernandez, "When you establish a many-to-many relationship
between a pair of tables, make certain you check each table and determine
whether there are any fields that you should transfer to the linking table."

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200606/1
.

Relevant Pages

  • Re: dual combo box
    ... store both values in the respective fields of this record; ... What you say is more "Database Correct", ... >able to access the value of the second column by linking ...
    (microsoft.public.access.forms)
  • Re: Rolling Up 3 Separate Tables
    ... relationships that you are going to database. ... This Department/Organization underneath the following Department/Agency ... of linking, the real linking is record to record, and the real work of ... to look at your publications table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: DB Self-destructed!
    ... I wasn't linking to anything. ... Quite some while back I'd imported an old DOS based database in ASCII tab ... I make a backup copy prior to every major ...
    (comp.databases.ms-access)
  • Re: Exclusively link to another Access Database
    ... >> backend MDB. ... Merely linking doesn't open the database exclusively. ... > write VBA code to open the back end database, create a recordset based on ...
    (microsoft.public.access.security)
  • Re: Science Nourishes the Mind and the Soul
    ... In the original sense of the word religion is a "linking ... back" to life's meaning; therefore, if morality is born of life's ...
    (talk.origins)