Hey i am building a website to hold sales accounts.
i have a table called sales and in that their is a column called price
nd i also hav another table called Payments
nd in that their is a field called total price
What i want is, it shud get data from "price" column from sales and all the rows and then put that final value into the "total price" of other table
how to do that please help
i have a table called sales and in that their is a column called price
nd i also hav another table called Payments
nd in that their is a field called total price
What i want is, it shud get data from "price" column from sales and all the rows and then put that final value into the "total price" of other table
how to do that please help