Help is much Appreciated

[Kookai]

Help please....
Im trying to do a database which base on documents that we received and we sent everyday from/to companies.

i come with 4 tables....
Document_register includes fields
Entry_No:
Type: (whether incoming or outgoing)
Doc_received/Sent:
Doc_reftext)
TypeWhether letter memo transmittal etc)-transmittal consist of Documents/Drawings which needs to be updated everytime bec of revision thats why i come up with 2nd table called document/Drawing register
Doc_Date:
From_Company:
Sender:
To_company:
Recipient:
Subject:
Issue For: (Info,action, review,comments)
W/attachments(Yes/No) - but i want if its tick a form called Document/Drawing Register will pop-up
Response Ref: (if there is any)(text)
Response Date:

then 2nd Table - Document/Drawing register include fields:
AD Reftext)
DE Reftext)
Title
Rev
Rev dte


Rev Status - (if its latest superseded)
Document stat - (Prelim Design etc)

Note that the 2nd table will be receiving same AD & DE reference but with different Doc Ref as the rev change.

3rd table - i come up with Document Response with fields
Response Ref: (text)
Response_date
Subject

4th Table is called ORganization:
ORg_ID: Text (this is where my From_Company & to_Company will look up the value)
Organization Name:
Organization Head: (this is where my Sender & Recipient will look up the value)
Contacts
Email

I have done so many relationships and mess up.... when i did a form and consist of fields for the 4 tables that i have its giving me error.

In my Document/Drawing Register, is it possible that i will just update the revision,rev date,status,doc_status instead of re-typing again & again the AD & DE Ref?

Can someone help me.. Please please

[NoellaG]

Hi,

here's a quick example of a doc revision structure. Of course, you'll have to adept it to your situation. Hope it helps.

NG