Page 5 When Ctrl-Backspace is used to clear the contents of the current Working Directory a character is placed at the beginning of the field. Use Backspace instead. Page 9 Solution 7 - It is necessary to click the Edit Data SpeedBar button to add a new record. Page 11 Solution 2 - To Italicize, select Font | Style from the menus and choose Italic. Page 14 Solution 3 - The Cut to Clipboard, Copy to Clipboard, and Paste from Clipboard buttons appear on both the Table View and Form View SpeedBars. There are three new buttons: Design, Print, and Table View. Page 27 Solution 2 - A secondary index is not automatically named. In the Save Index As dialog enter paydate as the Index Name. Paradox reserves the field name for single-field, case-sensitive indexes. Page 28 Solution 5 - A secondary index already exists for the State/Prov field. It is a single-field, case-sensitive index and therefore Paradox automatically named it State/Prov. To remove this index, click State/Prov, click Erase, and then continue with solution 5. Page 29 Solution 5 - After using the Save button to save your validity checks Paradox prompts you with a Restructure Warning dialog. Answer Yes to the question "Should the new and modified validity check(s) be enforced on existing data? Choose OK. You will be prompted twice. Page 54 Solution 1,2 - After choosing OK from the Design Layout dialog, Paradox will issue the warning "Your entire design will be replaced. Continue?". Choose Yes. Page 56 Solution 1 - To center the table in the form, select the table and click and drag from the center of the table until it appears centered. The instructions given in the guide are used to resize the table. Page 70 Solution 2 - Paradox will not automatically create the link for you. The Define Link dialog box will open. The dialog will show the link between Order No and Customer No. Double-click Customer No in the Field list to create the link between ORDERS.DB and CUSTOMER.DB. The Customer No field should appear under both tables. Also, Paradox will not link LINEITEM.DB and STOCK.DB on Stock No. You will need to create the link by double-clicking the Stock No field in the Field list. Page 71 Solution 3 - The Detail Table Style should be set to Table. Page 78 Solution 2, paragraph 3 - After clicking OK in the Design Layout dialog Paradox will prompt you with a warning "Your entire design will be replaced. Continue?" Click Yes. Page 78 Solution 2, paragraph 6 - After selecting the entire table, click and drag it down. The sentence incorrectly reads: select the entire table and then click and drag it up. Page 79 Solution 2, paragraph 1 - You will also need to delete the Amount Paid and Month fields. Page 79 Solution 2, paragraph 3 - The LINEITEM.DB Qty field should remain in the table. Delete the STOCK.DB Qty field. Page 80 Solution 1, paragraph 1 - As a default there is no extra space in the Report header and footer area. The manual must assume that there is space in the Report band because the band cannot be dragged in the direction requested. This step is not necessary. Page 80 Solution 1, paragraph 3 - Before adding the text object that says INVOICE, you may wan to delete the table name object in the Page band. Page 83 Solution 3 - Point just to the left of the bottom group band for Order No on the sidebar at the left side of the Report Design window and click. Page 86 Solution 1 - Disregard the sentence that reads: To define the field, click twice on the box after "Undefined field" to select it. Also, in place of the ellipsis (...) you may see More Fields... instead. Page 86 Solution 1 - After clicking Calculated, press Tab twice or click the the calculated field edit box. Page 89 Solution 1 - Click Labeled Fields to uncheck it. Page 92 Solution 1, paragraph 2 - CACUST.QBE already exist in the WORKBOOK directory, choose Yes to overwrite the file. Page 92 Solution 1, paragraph 3 - Error: Expression is invalid in a calculated field. The expression [Customer.City]+", "+[Customer.State/Prov]... refers to CUSTOMER.DB. This calculation must be redefined for ANSWER.DB. For example, [Answer.City]+", "+... You must correct the expression to view the data correctly. Do not save the changes to LABELS.RSL. Page 103 Solution 2 - Type ..f-@@.. in the Model Name field. Page 104 Problem 2 - Should read: Get a list of the orders totaling more than $1000.00 in the first half of 1992. Page 105 Solution 1 - The record contained in ANSWER.DB has the word Sportee in the Description field. Page 105 Solution 2 - The Type field does not exist in STOCK.DB. The field in reference here is called Description. You should get an empty ANSWER.DB unless you added new records with an empty Description field. Page 109 Solution 1 - There is a step missing - Before running the query, type the letters UK in the Country field so that answer table will be limited to just those orders from the United Kingdom. Page 109 Solution 2 - Shift is designed to select contiguous files in the File Name list. In this exercise use Shift click to select CUSTOMER.DB, LINEITEM.DB, and ORDERS.DB, but use Ctrl click to select STOCK.DB. Page 111 Solution - Should read: When the Add Table dialog box opens, click Type and choose Form from the drop-down list box that is open. Page 124 Solution 3 - This query returns an empty CHANGED.DB because there are no matches between Company in CONTACTS.DB and Name in CUSTOMER.DB. Use the CUSTOMER.DB and CONTACTS.DB in the Paradox for Windows sample directory instead. Page 134 Solution 4 - Paradox will not prompt for the table's password if the password was assigned in the current session of Paradox. You must exit and load Paradox again before proceeding to solution 4. Page 139 Solution 2 - The Type list does not include an option for Graphics in the Browser dialog box. To add a .BMP file to your folder, simply type the path and file name in the File Name: section of the Select File dialog. Solution 4 - CTRL-F4 will close PAYMTLOG.FSL and return you to the Folder. Solution 5 - Press ALT-F4 to close Paintbrush and return to Paradox. Page 144 Solution 2 - Paragraph two should read: When the ANSWER.DB is created, close it by CTRL-F4. Choose File | Utilities | Rename from the menus. Click :PRIV:ANSWER.DB under File Name:. You should see this table name show up under From:. Move the cursor to the box under To: and type cacust.db. Then click the View Modified Table button, and then on OK. Page 145 Solution 2 - Second to last sentance - click the OK button to complete the operation instead of the Add button. Page 145 Exercise 9.7 - The table referred to twice as DETAIL.DB is called LINEITEM.DB.