4 Replies - 688 Views - Last Post: 02 September 2013 - 05:24 AM Rate Topic: -----

#1 Cronos35  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 10-March 13

POS Database: Saving multiple items under one receipt number in a DB

Posted 28 August 2013 - 06:32 PM

Good day all!

I'm designing a Point of sales system as a project in our vb.net class. One problem i've been having is saving the items in my items purchase listview under a receipt number which is a random string of numbers and letters 10 chars long.

I want to save the receipt number in a database and under the receipt number are all the items purchased after confirming the purchase. Is this possible with sub datasheets or are there other tools i could use that would do better?

Is This A Good Question/Topic? 0
  • +

Replies To: POS Database: Saving multiple items under one receipt number in a DB

#2 tlhIn`toq  Icon User is online

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 5436
  • View blog
  • Posts: 11,651
  • Joined: 02-June 10

Re: POS Database: Saving multiple items under one receipt number in a DB

Posted 28 August 2013 - 08:12 PM

Table of line items, with one column being the receipt number.

receipt number | Line number | SKU 
----------------------------------
123                 1           987
123                 2           456
123                 3           345
111                 1           135
111                 2           888


Was This Post Helpful? 0
  • +
  • -

#3 Cronos35  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 10-March 13

Re: POS Database: Saving multiple items under one receipt number in a DB

Posted 28 August 2013 - 10:29 PM

View PosttlhIn`toq, on 28 August 2013 - 08:12 PM, said:

Table of line items, with one column being the receipt number.

receipt number | Line number | SKU 
----------------------------------
123                 1           987
123                 2           456
123                 3           345
111                 1           135
111                 2           888



thanks for the reply, but that's not the output i wanted. what i want is something like:
receipt number
123
 ->items
   *item1
   *item2
   *item3
1234
->items
   *item1
   *item2
   *item3


Was This Post Helpful? 0
  • +
  • -

#4 _HAWK_  Icon User is offline

  • Master(Of Foo)
  • member icon

Reputation: 1043
  • View blog
  • Posts: 4,057
  • Joined: 02-July 08

Re: POS Database: Saving multiple items under one receipt number in a DB

Posted 29 August 2013 - 06:20 AM

With the design tlhIn`toq showed you, the output would be what your showing. The database is just a storage place and when you query your data by receipt# you would get all the items that belong to it.
Was This Post Helpful? 1
  • +
  • -

#5 Cronos35  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 10-March 13

Re: POS Database: Saving multiple items under one receipt number in a DB

Posted 02 September 2013 - 05:24 AM

Riiight i tried looking at it again.. Thank you! That helped solved my problems.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1