Adding tasks to existing database

  • Thread starter Thread starter BillA
  • Start date Start date
B

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
 
BillA said:
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
Click to expand...

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
 
Back
Top