468,505 Members | 1,569 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

Row data transfer between tables using a form interface

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
Nov 13 '05 #1
1 3772
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Pete..... | last post: by
4 posts views Thread by Edward | last post: by
2 posts views Thread by Fatih BOY | last post: by
7 posts views Thread by Mark Waser | last post: by
10 posts views Thread by Doug Bell | last post: by
12 posts views Thread by joaotsetsemoita | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.