'merging' 2 tables

[Sniper-BoOyA-]

Good morning peeps,

Ive got a question regarding merging 2 tables, using a query.

Ive got a tabel : "tblproctor" ,which contains information about tests using the Proctor.

The 2 (most important) fields in this table are ProctorID and Sample nr

In this table the data looks like this

Proctor ID.....Samplenr
---------......--------
-- 1----........---1---
---2----........---8---

And i made a second table to give the user the opportunity to link more samples to a proctorID.

tabel "tblmnstrproct"

Proctor ID.....Samplenr
---------......--------
-- 1----........---2---
-- 1----........---3---
-- 1----........---6---
---1----........---9---
-- 2----........---4---
---2----........---7---
-- 2----........---10---

What i want to accomplish is to add the first set of data from table "tblproctor" to the second tabel, so u get a total list.

Ive tried several diffent ways, but i cant seem to figure out the best way of doing this. It either shows only the data of tabel "tblmnstrproct" or it shows both tables, but in 4 columns which will duplicate the data entry of tabel 1 to the amount of records in tabel 2.

Any ideas? Much appreciated!

 

[Sniper-BoOyA-]

I might have figured it out, at least the merging part..

I made a "add" query, (not sure if that is the right english word), which simply adds the ProctorID and Samplenr of table tblProctor to table2.

I am planning to run this query as soon as the user hits the "ok" button on the form to ass more samples to the excisting ProctorID's.