Agentshevy Posted April 20, 2016 Share Posted April 20, 2016 I have two tables Temporary and Real, the procedure is that contacts are created on the temporary table, probably by the contacts themselves. then once they have been confirmed as Clients (ie after their details have been verified by our staff), I would want to move them from the Temporary table to the Real table. Please how can I achieve this? Link to comment Share on other sites More sharing options...
comment Posted April 20, 2016 Share Posted April 20, 2016 Why is this a good idea - as opposed to entering the contacts into a single table, and confirming their client status by changing a field value? Link to comment Share on other sites More sharing options...
Agentshevy Posted April 20, 2016 Author Share Posted April 20, 2016 our Clients are being assigned ID upon confirmation that their details are correct. This ID can only be given after confirmation. so in essence, we plan to maintain a clean database of Clients as opposed to giving prospective Clients IDs of which they might end up not being one... That is the idea behind it Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2928 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now