2nd Round Supplement Application table

[SME]

I have one table with company information, linked to
another table with application information received from
said company based on a RFP. We are creating a 2nd round
of applications which would include some of the same
agencies, and additionally might include additional
agencies ... would it be better to create another table
for the 2nd round submissions? or just append to the
initial table(s). And if I append what would be the best
way to flag just the 2nd round applicants?

Many thanks in advance for any advice/guidence you might
be able to offer.

Regards,

/S

 

[Chris Nebinger]

I would keep all the application information together.
Creating a second table would then just lead to problems.
I would add a ApplicationRound field and add it to your
primary key.


Chris Nebinger