Prev: populating an Access table from a text file
Next: Access and Outlook Automation
From: Ling Yun on 4 Jun 2010 06:41
there are some suppliers of whitch i wanna record the information. one
supplier provides a lot of infomation so i must store them in the
database. one supplier with N information. so how to design the table
to store this data.
From: Tom van Stiphout on 4 Jun 2010 09:32
On Fri, 4 Jun 2010 06:52:54 -0400, "Douglas J. Steele"
<NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote:

Additionally you need a unique index (typically the Primary Key) over
the field(s) on the 1-side. On the fields on the many-side there is no
unique index or PK (otherwise you would get a 1:1).

Then you need to go in the Relationships form and draw the relation
from the field(s) on the 1-side to those on the M-side. It's also
highly recommended to enforce the relationship (see checkbox in
Relationship form).

-Tom.
Microsoft Access MVP


>You need two tables: one to hold the "1" information, related to one to hold
>the "N" information.
 | 
Pages: 1
Prev: populating an Access table from a text file
Next: Access and Outlook Automation