Copying Multiple Records from one table to another.

[Ryan]

I have a table with multiple records that remain static. They are questions
for an exam. I have another table that has some exam info, this table is
connected to another table that i want to copy the questions into. I would
like to be able to copy all of the records from the first table into the
third table with a linking field to link the third table to the second table.

any help would be appreciated.

Ryan

 

[Jeff Boyce]

Ryan

Moving records from one location to another (or copying them) is something
you'd do if you were limited to using spreadsheets. It's neither necessary
nor a good idea when using a relational database like Access.

If you'll describe what having the copied table of exam questions allows you
to do, folks here may be able to offer alternate approaches.

By the way, if you are working out an exam/survey database, consider looking
at the work Duane H. has already done on this topic:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Access MVP

 

[Ryan]

Hi Jeff,

I need to have alternating questions for the third table....only because it
is for auditing purposes..I would like to be able to change the first table
without effecting the third table data through the system. I have about 10
items a section that need to be audited. The first table wil not grow and
shrink a whole bunch but the questions might change..

 

[Jeff Boyce]

A simple query that returns, say, a random selection from the first table.

One additional field added to the first table to hold even/odd ... and a
query that selects "even " or "odd".

Alternate approaches ...


Regards

Jeff Boyce
Microsoft Access MVP