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
TableDocument: counter(primarykey,autonumber), DocNumber, DocTitle
TableRevision: counter, revision, DateRec'd