Help with Structure

crescent-centre

Registered User.
Local time
Today, 22:47
Joined
Feb 28, 2003
Messages
30
I have a database to record documents received on a project. 2 main tables, documents and revisions, each document can have many revisions. I have now been asked to add a section in for actions against each revisions, that is each revision can have many actions. Am having problems understanding how to add this table. The current database has several hundred records already and I do not really want to re-enter. Can someone help.
TableDocument: counter(primarykey,autonumber), DocNumber, DocTitle
TableRevision: counter, revision, DateRec'd
 
crescent-centre said:
I have a database to record documents received on a project. 2 main tables, documents and revisions, each document can have many revisions. I have now been asked to add a section in for actions against each revisions, that is each revision can have many actions. Am having problems understanding how to add this table. The current database has several hundred records already and I do not really want to re-enter. Can someone help.
TableDocument: counter(primarykey,autonumber), DocNumber, DocTitle
TableRevision: counter, revision, DateRec'd

Think I would make a few minor adjustments first

TableDocument: DocNumber(Primary key), DocTitle
TableRevision: DocNumber(Foreign_Key), revision, DateRec'd
set DocNumber and Revision as Unique Index

Then
TableRevision: DocNumber(Foreign_Key), revision, DateRec'd, Doc_Rev_Ref (Autonum, Primary Key)

TableAction
Doc_Rev_Ref_1 (Long Integer, Foreign Key), Action plus any other Action related fields. Here a PK set to autonum would be okay which would serve to give you an identity of each and every recorded action.

I have suggested the minor change to your original design to avoid the potential of duplications.


Len
 
Thanks Len

Needed to make a few minor changes to incorporate my structure but your solution works great.
 

Users who are viewing this thread

Back
Top Bottom