Re: can i make composite attributes in access

Tech-Archive recommends: Fix windows errors by optimizing your registry



In relationnal database, normalization rule zero is that a field must be
atomic, must have just one value. If you need to tie other stuff, then the
RECORD, with its primary key, can be seen as an 'attribute' and each of its
FIELD can match what you described here as a sub-attribute.


thanks...
(you are right ... but i know this)
Actually I wanted to know that how is this done in Microsoft Access
(preferably 2003 if it makes a difference).
btw thanks again..
.

Relevant Pages

  • Re: Access as a RDBMS--why the multiple relationships?
    ... I notice in Microsoft Access the relationship chart can, ... non-unique field in TABLE B. In the relationship diagram this shows ... referenced field is not a primary key, ...
    (comp.databases.theory)
  • Re: Ties in access query
    ... say randomness has been implied :-) ... a database being a tool to extract data. ... more sense, at the end, that just using a fixed primary key as tie-breaker. ... not even a hint of the existence of a possible "tie". ...
    (microsoft.public.access.queries)
  • Re: How to change the RowSource in a SubForm in VBA code
    ... It makes sense that the same problem situtions could arise when setting the subform's RecordSource on the fly. ... from the Database window onto another form or report or by using the ... Microsoft Access automatically sets the LinkChildFields ... primary key. ...
    (comp.databases.ms-access)
  • Re: Primary Key allowing duplicates
    ... I have one primary key. ... How do I tell Access to check for the duplicate value when the ... Not sure how to add the neccesary "stuff" in dlookup as ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: open form button
    ... > Doug Steele, Microsoft Access MVP ... >>> ID is the field name of your Primary Key ... >>> Primary Key field. ...
    (microsoft.public.access.forms)