Inserting multiple records

K

Kurt

Hey all,

Im hit a snag in the development of my database. I want to be able to create
multiple rows based on the primary key of another table. See, I have a time
table, which stores time values (fields include time ID (combination of year
and quarter), year, and quarter). Values range from 2004Q1, 2004Q2, 2004Q3,
2004Q4, 2005Q1.... 2010Q4. In another table (PersonProject, it stores some
account information, based on what the user has entered into a form. Now, say
the user enters in values for 2005Q1. I want these exact values to repeat
untill 2010Q4 in PersonProject, with only the time ID differing (Time ID is
part of the primary key, but is a foreign key from the Time table).

Now, is there a way to automatically replicate data for all time ID's beyond
the one entered? Or is the user going to have to enter the same values for
each quarter for each year (can become a big task).

Any advice would be appreciated!
Kurt
 
M

[MVP] S.Clark

Using some VBA with ADO or DAO, you can perform the desired data population.
If you are not versed in the art, there are plenty of professionals here
that would be happy to assist.
 
K

Kurt

Excelent! I thought about it last night, and Oracle would be able to perform
this function rather easy through the use of cursor's and insert statements.

Is there a way to get Access to perform this function? Im not very
proficient when it comes to access specifics regarding database coding and
advanced config, so any help is appreciated!

Cheers,
Kurt
 
Top