A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

2nd Round Supplement Application table



 
 
Thread Tools Display Modes
  #1  
Old September 22nd, 2004, 07:07 PM
SME
external usenet poster
 
Posts: n/a
Default 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  
Old September 22nd, 2004, 10:35 PM
Chris Nebinger
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.