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

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

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