Orders for HanDBase 1.0

Order entry applet using multiple groups of DB popups.
There are three files in this archive: orders.pdb, accounts.pdb, and products.pdb. All three are used for this applet. Heres how it works: Accounts.PDB - has accounts info- ie, your customers, their account number, their price rate, which is a discount rate that you could set for each customer. For example, a company might receive a 20% discount off the price, so this value would be 0.80. Products.pdb - information about each product you are selling, including product numbers, prices, description, etc. Orders.PDB - the main entry point once everything is set up. Open orders.PDB and add a record. You can choose the customer making the purchase by either writing in the value or, better yet, selecting the customer popup, where you will be taken to the Accounts database and you will be able to select one from the existing accounts. This will also bring over the account # of this customer. You can now fill out the quantities for up to 3 items (which was all I could fit in the 30 fields with all of the other stuff), and select the product by pressing the Item x Desc field and selecting the product from the Products database. The price will come over and be factored in along with the quantity, and the discount rate or price rate as it is in the accounts database is factored as well. At the bottom the tax is calculated, which I put in at 6%, which is Floridas rate, but you can easily modify this by adjusting the Tax field property, and a total is given. I hope this is a useful starting point for you. If you need more products to be purchased, you can either take away some of the other extraneous fields and try to squeeze one or two more in, or redesign the database as follows: Make each record be part of an order. You can use the new prev record calculated fields to keep a running sum. Then you can use the Filters to limit the view to the current customers current order only, and have a good subtotal!
System requirements:
- HanDBase v.3.0x or greater