transfer data between tables

[richerdh]

Hi guys, i am in sort of a dilemma here. Hope someone can help me.

I have a database with 3 tables named introducer, introducee and points.

In the table introducer, i have a field called "name". In the table introducee, i also have a field called "name".

what i would like to do is to auto transfer the data from "name" in introducee to "name" in introducer. How do i do this?

[MMcCarthy]

Hi guys, i am in sort of a dilemma here. Hope someone can help me.

I have a database with 3 tables named introducer, introducee and points.

In the table introducer, i have a field called "name". In the table introducee, i also have a field called "name".

what i would like to do is to auto transfer the data from "name" in introducee to "name" in introducer. How do i do this?

question is being moved to the Access forum.

ADMIN

[Rabbit]

What do you mean by auto transfer? When and how do you want this to happen?

[richerdh]

What do you mean by auto transfer? When and how do you want this to happen?

I am doing a database for a property promotion. So when lets say John (introducer) recommends Mary (introducee) to purchase a property, John will get some redemption points.

Soon, Mary(introducee ) will also recommends someone else (matt) to buy a property. This will make Mary(introducee ) to become an introducer.

For this I made 3 tables - introducer, introducee and points for this database. So when Mary(introducee ) purchase a property, i would keyin her datas into the introducee table.

Soon Mary will also recommend someone else (matt) to buy a property. This will make Mary to be an introducer.

Since now I already have Mary's detail in the introducee table, I want to be able to transfer her details to the introducer table, without typing all her datas again into the intoducer table.

How do i do this??

[MMcCarthy]

I am doing a database for a property promotion. So when lets say John (introducer) recommends Mary (introducee) to purchase a property, John will get some redemption points.

Soon, Mary(introducee ) will also recommends someone else (matt) to buy a property. This will make Mary(introducee ) to become an introducer.

For this I made 3 tables - introducer, introducee and points for this database. So when Mary(introducee ) purchase a property, i would keyin her datas into the introducee table.

Soon Mary will also recommend someone else (matt) to buy a property. This will make Mary to be an introducer.

Since now I already have Mary's detail in the introducee table, I want to be able to transfer her details to the introducer table, without typing all her datas again into the intoducer table.

How do i do this??

You don't you only store her details once and use a foreign key reference to the table in which her details are stored. Have a look at the following tutorial.

Normalisation and Table structures

Mary