-1

I'm attempting to create a "point of sale" program. Where the user can enter stock into a database, as well as customers etc. I want to be able to create a "Job" where I can enter several stocked items from the database, enter customer information, click save, and then when I click sold it turns it into a printable invoice. I use this software at work :
http://www.mamsoftware.com/en/autopart-tyres
And would like to do something similar to the picture (although its not very clear) But you basically type the stock item into it, it finds the price etc from the database, and you then assign a customer to it, and click "save" or "invoice". Would I have to create a new datatable and save it into the database for each one, assign a unique number to it (for reference).

user3237403
  • 163
  • 1
  • 2
  • 10

1 Answers1

0

Will be better to store all the data in a database. At least is my point of view! And you will be able to export as excel if you want too.

Oscar Bralo
  • 1,912
  • 13
  • 12
  • Would I be able to create a datatable for each invoice, if you get where I'm coming from ? – user3237403 Feb 27 '14 at 21:59
  • I think that you can create a table called invoices, and each invoice will be a row. Then, you can retrive from the database all the invoices for a client, and show as you want ;) – Oscar Bralo Feb 27 '14 at 22:01
  • But I'd need to add multiple stocked items to it, including prices and quantities etc, Would it work that way or would I need to create a new table for each "job"? – user3237403 Feb 27 '14 at 22:02
  • I think that you can add another table, then add in that other table the stocked items, with an ID which reference to each invoice in the invoice table ;) This way you will be able to retrive all the stocked items with the same id that the invoice – Oscar Bralo Feb 27 '14 at 22:03
  • Do you know of any tutorials for what I need to do ? – user3237403 Feb 27 '14 at 22:05
  • mmmm, nop, so sorry! But i think that if you know something about SQL will be not hard for you to create ;) – Oscar Bralo Feb 27 '14 at 22:06
  • True, So I can create a new table for each job, add the stocked items as needed, add a customer, then create a unique reference number for it, and access it from another table to be viewed, printed etc? – user3237403 Feb 27 '14 at 22:08
  • Yeah ;) you got the idea! ;) – Oscar Bralo Feb 27 '14 at 22:14