help Please :-(

[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_ref:(text)
Type:(Whether 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 Ref:(text)
DE Ref:(text)
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

[Kookai]

Anyone....

[pkstormy]

Your question is to vague to answer (especially since we are not familiar with all the info you supplied.)

You've supplied info which is near impossible for us to answer without fully understanding your fields and what you're specifically trying to do.

You may want to rephrase your question to something specific versus giving us a bunch of field names which don't make any sense to us.

ie. "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?"

I have no idea what you're trying to do based on this statement. I'm 'guessing' that you possibly need to set the default value of certain fields 'somewhere' in your coding.

me.myfieldname.defaultvalue = "=" & somevalue