move data from one table to another

hi,

if i have my lead table and want to convert this to a sale, i need to move the data from the lead table keeping the assigned salesmanuserid to this but have it so it does not show in my leads table anymore instead now a sale.

i want to have a button in the leads details page which they click and and then moves it into the sales page?

can any webassist tech help with this?

many thanks

It doesn't make sense to move the data from one table to another in this case.

the record can only be a lead or a sale right?

So create a column to designate the record as such.

all of the leads and sales are stored in one table, you have a column to designate the record as a lead or sale

using this column, you can create a where clause to search for all leads, and another to search for all of the sales.

thansk jason, so create a column in the clients table with say "status" either "lead or sale" then filter out like you said?

many thanks

Yes, exactly:
WHERE status='lead'

or:
WHERE status='sale'

cheers jason

hi jason,

just a quick one, by creating this column i need to be able to later in the database show a graph say from dynamic web charts or even just a basic report of lead conversion to sale by user?

how can this track this if it just changes from lead to sale in db?

many thanks

also jason, say i have a products table, clients table and users table.

if i want to see clients assigned to users i create a foreign key from userstbl to clientstbl.

now clients will have multiple products but be assigned to the one user, so you would again create a foreign key from clientstbl to productstbl. do i need a foreign key from userstbl to productstbl or is there no need as there is a foreign key from clientstbl to userstbl?

many thanks again

You would need to create another column to mark it as a conversion. set the default value of the conversion column to 0, when you update the record from a lead to a sale, updater this column to a one as well.



You will only need to have a foreign key relation from the from userstbl to productstbl if the user can be related to different products than the client. If the user is related only to the same products that the client is related, there is no need to relate the user table to the products table.

thanks jason so would the conversion column be in the clienttbl?

so:

status - drop down
&
Conversion - 0 or 1

?

many thanks again

It would be in the same table that contains the status column.