By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

How best to add new records (Long)

P: n/a
I'm building an application to monitor progress against Technical Activity
numbers. I have two tables:

tblTechAct
TechnicalActivity (PK)
Description
ActualStart
ActualFinish

tblProgress
TechnicalActivity (FK)
WeekNo
Progress

The app imports data from another system (Oracle) and the data is used to
populate an Excel spreadsheet with Week Number columns containing the
progress data.

In an ideal world I would import the Technical Activity numbers into
tblTechAct and then import progress data on a weekly basis. BUT ... of
course the list of Technical Activities will grow with time and, because of
the nature of the Excel spreadsheet, I need to "fake" previous weeks'
progress for new Technical Activities (the Excel spreadsheet is created from
scratch every time the routine is run, it is not an existing one that is
"added to" each week).

So for example, if TA No XYZ123 is added in Week 750, I need to add an entry
for it in tblProgress for weeks 720 onwards at 0% progress.

My question is, what is the best method of doing this? Importing into
tblTechAct is easy but what about tblProgress? My immediate thought was to
have a query to identify numbers in tblTechAct that aren't in tblProgress
and write a function to add a record for each unique entry in the WeekNo
field. Do I need a function or can it be done in queries.

Sorry about the rambling post, I hope it makes sense.

Many thanks.

Keith.

Jul 24 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Keith Wilby" <he**@there.comwrote in message
news:46**********@glkas0286.greenlnk.net...
I'm building an application to monitor progress against Technical Activity
numbers. I have two tables:
Maybe a better way would be to NOT add dummy records and code accordingly
.... but how?!

Jul 24 '07 #2

P: n/a
"salad" <oi*@vinegar.comwrote in message
news:Ey*******************@newsread1.news.pas.eart hlink.net...
>>
Sorry about the rambling post, I hope it makes sense.

Not really. That's why if I take a stab at it and I flub it I can point
my finger at you. :-)
Hi salad and thanks for the response. As is often the case, after posting
this I thought of an alternative method that doesn't require the addition of
dummy records at all. I think I'd gotten into a bit of a blinkered state
with this but I think they're off now ... for a while anyway ;-)

Regards,
Keith.

Jul 25 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.