Row data transfer between tables using a form interface

[DataB]

Hi Everyone!

I have, essentially, two table structures in the same ms access
database file. Both are of the parent-child format, one parent table
with personal details, then multiple child tables keeping specific
information, all child tables being linked to the parent in a 1-to-1
relationship on primary key value.

I have 2 structures like this. One for "Applicants", one for
"Members".

I need to create a way, such that, when a user views a certain
Applicant on a single form with all the parent and child information
presented on the one form, they can then hit a button and transfer
that single person to the "Members" table structure.

Essentially, I need to insert a copy of all the information for that
single person being viewed on the form into the Members table
structure, then delete that person from the Applicants table
structure.

But I can't figure out how to do it! I'm not sure how to reference
ONLY the pesonal information being viewed in the form at that time in
SQL using first and insert statement, then a delete statement.

Help!

Thanks very much for your help!

A

[PC Datasheet]

An easy way to do what you want is to create a new table called TblStatus that
looks like:
TblStatus
StatusID
Status

The table would contain two records:
1 Applicant
2 Member

Then add a StatusID field to your current members table and delete your
applicants table. Add a bound combobox for StatusID on your member form and
delete your applicant form. Enter everyone in your one form marking the status
appropriately. When you want to delete applicants who never became members, use
a delete query based on your one table with 1 in the StatusID field.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"DataB" <ab******@hotmail.com> wrote in message
news:6c**************************@posting.google.c om...

Hi Everyone!

I have, essentially, two table structures in the same ms access
database file. Both are of the parent-child format, one parent table
with personal details, then multiple child tables keeping specific
information, all child tables being linked to the parent in a 1-to-1
relationship on primary key value.

I have 2 structures like this. One for "Applicants", one for
"Members".

I need to create a way, such that, when a user views a certain
Applicant on a single form with all the parent and child information
presented on the one form, they can then hit a button and transfer
that single person to the "Members" table structure.

Essentially, I need to insert a copy of all the information for that
single person being viewed on the form into the Members table
structure, then delete that person from the Applicants table
structure.

But I can't figure out how to do it! I'm not sure how to reference
ONLY the pesonal information being viewed in the form at that time in
SQL using first and insert statement, then a delete statement.

Help!

Thanks very much for your help!

A