I
Hello Alls
I have a little know how of Access Database. Presently I am working in a construction company who keeps its Drawings record in Excel format. Our system is like this
QQQ is Client
EEE is Contractor
PPP is Sub-Contractor
Now the situation is that PPP design a Drawing and send it to EEE, then EEE send it to QQQ for Review / Approval. If is approved then OK and no problem. but if QQQ give its comments it reverse to EEE and then to PPP. So our drawing approval cycle is give below:
Step 1 PPP design drawing in Rev 0 and send it to EEE
Step 2 EEE send this drawing to QQQ
Step 3 QQQ send it back to EEE with its comments
Step 4 EEE send it back to PPP
Step 5 PPP incorporate comments and send it to EEE in Rev 1
Step 6 EEE again send it to QQQ
Step 7 QQQ approve it or again make some changes
So this is the story. Our company is using an Excel Sheet which records
Dwg No
Rev
Xmtl No form PPP
Xmtl Date.
Then we send it to QQQ
Dwg No
Rev
Xmtl No to QQQ
Xmtl Date
So it become a LONG ROW to see where the drawings and what is its current Rev and Status (approved or still in approving process).
I want to make a database in Acces. I don't understand how to see all this Drawings incoming and outgoing in ONE SINGLE SCREEN.
Can anybody please help me to guide / advise a way out of this. Or if there is a template of Revision Based Entry / Repeated entry between 3 companies.
I will be thankful to all friends. I want to do something which can improve my status in new company... OK dear... I will wait for your suggestions / advise.
Irshad Ahmad
I have a little know how of Access Database. Presently I am working in a construction company who keeps its Drawings record in Excel format. Our system is like this
QQQ is Client
EEE is Contractor
PPP is Sub-Contractor
Now the situation is that PPP design a Drawing and send it to EEE, then EEE send it to QQQ for Review / Approval. If is approved then OK and no problem. but if QQQ give its comments it reverse to EEE and then to PPP. So our drawing approval cycle is give below:
Step 1 PPP design drawing in Rev 0 and send it to EEE
Step 2 EEE send this drawing to QQQ
Step 3 QQQ send it back to EEE with its comments
Step 4 EEE send it back to PPP
Step 5 PPP incorporate comments and send it to EEE in Rev 1
Step 6 EEE again send it to QQQ
Step 7 QQQ approve it or again make some changes
So this is the story. Our company is using an Excel Sheet which records
Dwg No
Rev
Xmtl No form PPP
Xmtl Date.
Then we send it to QQQ
Dwg No
Rev
Xmtl No to QQQ
Xmtl Date
So it become a LONG ROW to see where the drawings and what is its current Rev and Status (approved or still in approving process).
I want to make a database in Acces. I don't understand how to see all this Drawings incoming and outgoing in ONE SINGLE SCREEN.
Can anybody please help me to guide / advise a way out of this. Or if there is a template of Revision Based Entry / Repeated entry between 3 companies.
I will be thankful to all friends. I want to do something which can improve my status in new company... OK dear... I will wait for your suggestions / advise.
Irshad Ahmad