Price Book Update Program

Purpose: 
     This program enables a site to receive a corporate update file (pbdnld.hld). The site can then edit the file information and save it to a database. All items are displayed in 3 tables. These represent the 3 different types of records. Once the data is edited the data can be saved to the database for future changes. The data can also be passed to a new import file (pbdnld.new) When the database is updated the tables are cleared and compressed to clean the tables then new data is added. I backup database is also created when this process occurs (sncDB.mdb). This file is deleted when the next update is performed. 

Files and placement:
Pbdnld.hld should be located in the c:\pos dir
If this file does not exist, an open file dialog box will appear to allow for selection of the update file.
Pbdnld.new is placed in the c:\pos directory.

SNCENTDB.MDB Should be located in the c:\sncdb Directory

SNCDB.MDB is created in the c:\sncdb Directory

PBUPDate.exe The executable program has no restrictions on were it runs. 

Program Operation:
 When the program starts, there will be two buttons on the screen. The two options are to load data from the Import File (pbdnld.hld) or from the Database (SNCENTDB.MDB).
Either choice will load the screen with 3 tables. Select either button.

Price book screen
 This screen displays three tables that display all the pricebook items from either the database or the download file. The three data tables are 1. Header information, 2 Price Information and 3 User Defined Information.   Updating Data

Two Buttons appear on the table screen
Write Data to Import File This will create a new file with all changes made (pbdnld.new) the file is in the C:\pos Directory

Load to Database This will update the database with all new information.

Updating Data
       The program provides three tables with all the data displayed to the user. Click on the item number in the first column will display a screen with all information that can be changed. Click on any box and change the information using the mouse and keyboard Pressing Enter or Tab will tab to next box. Two tables will appear that show only the items that apply to the selected item. Click on the first column of any item requiring updates. A new screen will appear for information editing. Each of these screens has three buttons to Add New Item, Save Update and Cancel Edit
Add New Item allows the new item to be added. 
     Restrictions are built in to not allow duplication in Table 1. Tables 2 and 3 allow for additional records per Item. 
Save Update Updates the item selected. 
Cancel Edit exits the edit screen without updating the item.