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??