AnsweredAssumed Answered

Adding products to a "ticket" from found items

Question asked by WilliamdelaMaza on Feb 22, 2011
Latest reply on Feb 22, 2011 by philmodjunk


Adding products to a "ticket" from found items


I'm working on a db solution for a bookstore that besides cataloguing all their inventory, could be used to find book titles and -if they're available- be able to add them to a ticket table that will print a ticket.

I've got two tables:

  1. Products
  2. Tickets

I've set the primary key to be a field on products called ProductID which is related to its child table "Tickets". On tickets I've got several foreign key fields that borrow information from the Products table such as book title and price.

What I need to do -but don't have a clue as to how to- is for the user to be able to look for one or more book titles on the product layout and then be able to add them to the ticket layout like in a shopping cart via a button.

Could anyone point me in the right direction?

Thanks beforehand!