Help to defining how many tables and how to relate them together.

[jschou]

I have started quite a task for my self. At work we have to review a lot of documents each week, we have to sign of that we have done the task. We have to have a record of who did what document at what time. We also have to be able to see deadline for the next review and if any documents will go past due within a specific time.


A have a lot of different information on the documents on where they are located, what print number, who is the owner, what the status of the document and on what period are the specific document up for review.

I have a fairly idea on how to do all the forms and reports and queries but I am in doubt on the design on tables and the database.

All help welcome..

Best regards.

Jschou

[ranman256]

Most likely you want ...

tProject
--------
projID. Autonum
name
description
etc


tTasks
--------
TaskID. Auto
projID. Long
taskName
taskDate
comleteDate
userid

tDocs
--------
DocID. Auto
projID. Long
docName
descr.

[jschou]

thanks, I will see if it makes good meaning for the data in the database.. best regards