If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2nd Round Supplement Application table
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 |
#2
|
|||
|
|||
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 -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
Linked table getting Application Error | Eric | Mailmerge | 3 | June 13th, 2004 11:08 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Table design | BillT | New Users | 11 | May 25th, 2004 03:41 PM |
Application of "Rank" formula to a table | MY | Worksheet Functions | 1 | October 2nd, 2003 08:55 PM |