hello,
I have a large database full of sales information. Call this TotalSalesDB
I want to make a form, where a sales manager will type in the sales they have accomplished for the day. This information is stored in a table, lets call this DaySalesTbl.
The sales manager will enter all the information in the form that populates the table DaySalesTbl. After that I want a "submit button", which when pressed, will add all the data from DaySalesTbl to TotalSalesDB.
Now when i mean 'add', i don't mean anything fancy, just literally put one table on top of another.
Both DaySalesTbl and TotalSalesDB have the same number of fields with the same data types.
for example
if DaySalesTbl is:
X | Y | Z
---------------
1 | 2 | 4
4 | 3 | 1
and TotalSalesDB is:
X | Y | Z
---------------
9 | 8 | 8
7 | 7 | 7
6 | 6 | 6
Then after the "submit" button is clicked and they are combined, TotalSalesDB should look like
X | Y | Z
---------------
9 | 8 | 8
7 | 7 | 7
6 | 6 | 6
1 | 2 | 4
4 | 3 | 1
Any help would be greatly appreciated! this is for my internship in Citibank so yes, very appreciated