If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Correlation
Hi can anyone help me,
I have just graduated and have started working for a building developer which deals with a large quantity of drawings. As you can imagine these all need documenting and revision of drawings kept a track of. I have recently taking over the administration of the drawings and their current system is not capable of easily managing the data so I have taken it upon myself to try and organise the data in a database. The problem arises when displaying the drawing numbers with the revision dates and revision letters like below in a grid fashion. Day 1 17 9 20 11 Month 3 6 8 1 5 Year 02 02 03 04 04 Drawing Num Drw1 - A B Drw2 - A B C Drw3 - A B Drw4 - I have studied database systems during my degree (IT related) but either I have forgotten or not come across how to do this. If anyone can help my by either pointing in a direction of where to look or similar databases that use a similar grid technique I would be very grateful, I'm not stupid and am prepared to put the work in to get the right result. Also as this is the DB design forum, how would i go about orgaising the data, may be where i am going wrong. One last thing, as this is being used in an office I only have access to limited facilities and software that is on offer so the only database available is MS Access XP, very annoying having studied and worked with Oracle. Thanks in advance Les |
#2
|
|||
|
|||
It isn't clear at all what determines where in your grid what is displayed.
You have to store something in tables that describes the location. You haven't provided this and haven't provided any table structures. -- Duane Hookom MS Access MVP "Les" wrote in message ... Hi can anyone help me, I have just graduated and have started working for a building developer which deals with a large quantity of drawings. As you can imagine these all need documenting and revision of drawings kept a track of. I have recently taking over the administration of the drawings and their current system is not capable of easily managing the data so I have taken it upon myself to try and organise the data in a database. The problem arises when displaying the drawing numbers with the revision dates and revision letters like below in a grid fashion. Day 1 17 9 20 11 Month 3 6 8 1 5 Year 02 02 03 04 04 Drawing Num Drw1 - A B Drw2 - A B C Drw3 - A B Drw4 - I have studied database systems during my degree (IT related) but either I have forgotten or not come across how to do this. If anyone can help my by either pointing in a direction of where to look or similar databases that use a similar grid technique I would be very grateful, I'm not stupid and am prepared to put the work in to get the right result. Also as this is the DB design forum, how would i go about orgaising the data, may be where i am going wrong. One last thing, as this is being used in an office I only have access to limited facilities and software that is on offer so the only database available is MS Access XP, very annoying having studied and worked with Oracle. Thanks in advance Les |
#3
|
|||
|
|||
What's displayed is the drawing number, with the revisions (-,A,B,C...) with
the date of the revisions (Day, Month,Year) above the revision letter. This hasn't displayed how it was originally produced, apologies. As for the table structure, I have one table containing the drawing details (TABLE_DRAWINGS: drawing_id, drawing_number, drawing_description) and another containing the drawing revisions (TABLE_REVISIONS: drawing_id, drawing_issue, drawing_issuedate, drawingissue_comments). Both are linked and working well, my problem comes when I try to display the drawing number with the revision letters following with the date of the revision listed above it (i.e.. the date becomes the column heading and the drawing number the row heading giving a gird like effect). If other drawings are issued on the same date, that revision letter is also listed on the same date row. This has tried to be shown below but due to a non-fixed font, it has mess up my formatting. Hope I have explained myself better, Les "Duane Hookom" wrote in message ... It isn't clear at all what determines where in your grid what is displayed. You have to store something in tables that describes the location. You haven't provided this and haven't provided any table structures. -- Duane Hookom MS Access MVP "Les" wrote in message ... Hi can anyone help me, I have just graduated and have started working for a building developer which deals with a large quantity of drawings. As you can imagine these all need documenting and revision of drawings kept a track of. I have recently taking over the administration of the drawings and their current system is not capable of easily managing the data so I have taken it upon myself to try and organise the data in a database. The problem arises when displaying the drawing numbers with the revision dates and revision letters like below in a grid fashion. Day 1 17 9 20 11 Month 3 6 8 1 5 Year 02 02 03 04 04 Drawing Num Drw1 - A B Drw2 - A B C Drw3 - A B Drw4 - I have studied database systems during my degree (IT related) but either I have forgotten or not come across how to do this. If anyone can help my by either pointing in a direction of where to look or similar databases that use a similar grid technique I would be very grateful, I'm not stupid and am prepared to put the work in to get the right result. Also as this is the DB design forum, how would i go about orgaising the data, may be where i am going wrong. One last thing, as this is being used in an office I only have access to limited facilities and software that is on offer so the only database available is MS Access XP, very annoying having studied and worked with Oracle. Thanks in advance Les |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Data Source issues. ??data.access.pages | Phil | Database Design | 2 | October 11th, 2004 02:42 AM |
Data Source issues | Philippe | Database Design | 1 | October 10th, 2004 09:45 PM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |