Append record to another table with different field values

  • Thread starter Thread starter Chadi Ghazal
  • Start date Start date
C

Chadi Ghazal

hi there,
i have a problem while appending records from one table to another
here is a small description of my problem:

i have two tables materials and results
i want to read all materials in a specific class from the materials table
and append them to the result table. but in the result table i want to add
the same material for each semester.
for example: if i had in a specific class math and english i want to append
to the result table empty records containing math and english for each
semester so i will get math and english for the first semester and again
math and english for the second semester etc... while at the same time being
able to update the semester id in the result table

can somebody help

thanks
 
hi there,
i have a problem while appending records from one table to another
here is a small description of my problem:

i have two tables materials and results
i want to read all materials in a specific class from the materials table
and append them to the result table. but in the result table i want to add
the same material for each semester.
for example: if i had in a specific class math and english i want to append
to the result table empty records containing math and english for each
semester so i will get math and english for the first semester and again
math and english for the second semester etc... while at the same time being
able to update the semester id in the result table
Click to expand...

A "Cartesian join" query might be useful here... IF you in fact want
to do this. Storing empty, or identical, "placeholder" records is
rarely a good idea, nor is it wise to store data redundantly - I'm not
sure you're doing this or not!

That said... if you have a small (three row?) table containing all the
semesters, and another small table containing all the courses, you can
create a Query by adding both tables to the query grid *without* any
join line. It will give you every possible pairing of course and
semester. You can then append this Query to your results table.
 
Back
Top