470,647 Members | 1,313 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

table design and history

I am new to Access and I would like to do something very simple and
probably very common:

PK Type
PK CreationDate

PK Type
PK CreationDate

PK Type
PK CreationDate
PK TypeA -Type@tblTypeA
PK TypeB -Type@tblTypeB

TypeA and TypeB in tblTypeC should have referencial integrity and update
(not delete) while the relation is many-to-many due to the history of
each Types, that is many tblTypeC can refer to many tblTypeA and vice et

The problem is the links TypeA and TypeB in tblTypeC which do not accept
referential integrity (No unique index found). I know that many-to-many
links should be done using junction tables (putting TypeA and TypeB into
two separate tables), but since this scheme appears in all our tables,
it would require a lot of small tables to create these many-to-many
links (all tables needs to manage an "history" of the records, therefore
this would double the number of tables). I don't know if the use of APK
would be better since I am not sure that I could ensure uniqueness of
the combination of the PK fields in tblTypeC for example.

Any clue about such design?


Oct 16 '06 #1
0 1090

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Martin Mrazek | last post: by
47 posts views Thread by Neal | last post: by
15 posts views Thread by kimi | last post: by
3 posts views Thread by John Baker | last post: by
8 posts views Thread by chrisoftoday | last post: by
3 posts views Thread by Prochot | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.