Adding tasks to existing database

[BillA]

Having a little difficulty with what I believe should be simple.

I have a project tracking db, which tracks project until it is approved.
I’ve been asked to introduce additional tasks; Renewals and Amendments.
Unlike tracking the approval process, a project will have multiple renewals
and amendments. Each renewal and amendment will have many of the same fields
used to track the project approval (mostly date fields). Additionally, I
would need to introduce commenting for each instance of a renewal or
amendment, and each renewal or amendment may have zero or many comments.

I’m having designer block. I would like advice for how to introduce the
renewal and amendment, and connect corresponding comments (from a comments
table?).

Ultimately, from a users perspective, we would like to have a form that
shows project information and will have tabs for “Application†“Renewal†and
“Amendment.†I’ve included the main table named “tbl_Project†which the
renewal and amendment would be tied to.

Table: tbl_Project
ProjectID
RequestType
ProjectNumber
DateReceived
StudyTitle
StudyHasWebPage
ApprovalDate
StatusDescriptionID (lookup – open/closed/withdrawn/pending/denied)
[Etc…]

Thank you for any advice.
Bill

 

[Evan Keel]

Having a little difficulty with what I believe should be simple.

I have a project tracking db, which tracks project until it is approved.
I've been asked to introduce additional tasks; Renewals and Amendments.
Unlike tracking the approval process, a project will have multiple renewals
and amendments. Each renewal and amendment will have many of the same fields
used to track the project approval (mostly date fields). Additionally, I
would need to introduce commenting for each instance of a renewal or
amendment, and each renewal or amendment may have zero or many comments.

I'm having designer block. I would like advice for how to introduce the
renewal and amendment, and connect corresponding comments (from a comments
table?).

Ultimately, from a users perspective, we would like to have a form that
shows project information and will have tabs for "Application" "Renewal" and
"Amendment." I've included the main table named "tbl_Project" which the
renewal and amendment would be tied to.

Table: tbl_Project
ProjectID
RequestType
ProjectNumber
DateReceived
StudyTitle
StudyHasWebPage
ApprovalDate
StatusDescriptionID (lookup - open/closed/withdrawn/pending/denied)
[Etc.]

Thank you for any advice.
Bill

Need some addtional information:

Define Renewal

Define Amendment

Please list the attributes of a Renewal. Same with Amendment.

How are Renewals and Amendments different? How are they the same?

Evan