Update one table with another using criteria

[Guest]

Hi,

I have a main database with several child on a form separated by tabs. I
have an applicant child table (table A) with several fields including a
qualified and a disqualified fields. I want to transfer five fields from the
five first applicants that meet the qualified criteria to a second child
table (create new records) called short list (Table B).

- each children tables are "bound" by the file number fields to the main table
- children table are not "bound" togheter
- disqualified records can exist in the first five records of Table A

I would like to be able to push a button to transfer the fields.

Anyone can help?

Thanks,
Marc

 

[John Vinson]

Hi,

I have a main database with several child on a form separated by tabs. I
have an applicant child table (table A) with several fields including a
qualified and a disqualified fields. I want to transfer five fields from the
five first applicants that meet the qualified criteria to a second child
table (create new records) called short list (Table B).

- each children tables are "bound" by the file number fields to the main table
- children table are not "bound" togheter
- disqualified records can exist in the first five records of Table A

I would like to be able to push a button to transfer the fields.

The simplest way would be to run an Append query appending the
selected records from TableA to TableB.

There's no such concept as "the first five records" though! A Table is
an unordered "heap" of data. You can limit the append query to append
five records using the Top Values property of the query, but you'll
have to have some field or fields in TableA which determine which five
records are the "first".

The Append Query can be run from a command button on the form; the
button wizard offers "run a query" as one of its options.

John W. Vinson[MVP]