Hi!
Been looking for an easy to set database and decided to give the trial a try. I have never tried to set up a database before so these things are really new to me.
What I wonder is how I update a table. I have three tables, one with title and UPC(barcode number), one with UPC and amount of each, and one table with UPC and a date( date which the item has been uploaded to the auction). (I sell things on QXL, the auction site).
So what I wonder about is what the most efficient way to update the tables with regard to:
1. How to update(change) each variable as date(of when the auction started, its a max of three weeks and I want to be able to query auctions which has passes the three weeks with out beeing sold so I can reload them without have to check my inventory manually)
Since I dont put all of my items out on the auction on the same date I hope there is an easy way of updating tables so it can search for the UPC nr and then update the corresponding data variable. The same goes for when I sell lets say ten items and want to update the amount variable. I get sales report in excel format with the UPC and ideally would want to import the data into the correct table.
As you all can see I don't know much about these things are would deeply appreciate help.
Regards
Kim
Been looking for an easy to set database and decided to give the trial a try. I have never tried to set up a database before so these things are really new to me.
What I wonder is how I update a table. I have three tables, one with title and UPC(barcode number), one with UPC and amount of each, and one table with UPC and a date( date which the item has been uploaded to the auction). (I sell things on QXL, the auction site).
So what I wonder about is what the most efficient way to update the tables with regard to:
1. How to update(change) each variable as date(of when the auction started, its a max of three weeks and I want to be able to query auctions which has passes the three weeks with out beeing sold so I can reload them without have to check my inventory manually)
Since I dont put all of my items out on the auction on the same date I hope there is an easy way of updating tables so it can search for the UPC nr and then update the corresponding data variable. The same goes for when I sell lets say ten items and want to update the amount variable. I get sales report in excel format with the UPC and ideally would want to import the data into the correct table.
As you all can see I don't know much about these things are would deeply appreciate help.
Regards
Kim
Comment