Thanks for the clarifications. I will work on your suggestions once I recieve the .odt file and get back if I need further help.
--Sowbhagya ________________________________ From: Elder Dan Lewis <[email protected]> To: [email protected] Sent: Saturday, September 12, 2009 6:37:06 AM Subject: Re: [authors] Attention Dan Lewis: Doubts while reviewing Chapter1 of Base Guide Sowbhagya Sundaresan wrote: > Hi Dan, > > I have been reviewing the First Chapter for the Base Guide. In doing so, I > have followed the instructions step-by-step and tried to construct the sample > Financial database and I have certain questions regarding that. > > As I understand, in Section 1.4.1.2, the intent is to create 2 basic tables: > Main and Expenses. > In 1.4.1.3.1, the HouseholdInventory table is created. > > In 1.4.1.3.2, the Expenses table is created. The fields added to this table > (MainID, Date, Number, Payee, Amount, Note, Signature) do not include the > fields(Budget, Subbudget etc.) suggested in Table 8. > So Question 1: > Should we add those fields to the Expenses table? This was an error on my part. In 1.4.1.3.2, the table created was the *Main* table. Please replace the name /Expenses/ with the name /Main/ in Step 3 2) on page 39. Also on page 40, the statement just below Figure 14 should read: "This table is created the same way way that the Main table was just created. Clearly I had not written how to create the Expenses table. (I only thought I had.) > > In 1.4.2, a relationship is established between Main and Expenses table. But > Main table has not been created anywhere so far. > So Question 2: > Should we mention about creating the Main table somewhere in Section 1.4.1.3 > with the fields suggested in Table 8? > As mentioned in question #1, it is the Expenses table that has not been >created rather than the Main table. At this point, I am considering creating a >table at the end of section 1.4.1.3.2 (page 39) listing the field names, field >types, descriptions, and properties for the Expenses table. The reader should >be able to follow the instructions in this section to create the Expenses >table. A little later, I will send you this table in a frame in an .odt file. >I will appreciate if you copy and paste the entire frame to the very top of of >page 40. That means the frame containing Figure 14 will need to be moved >further down the page to fit properly. I will also include a screenshot >showing how it should look. > And Question 3: > How does HouseholdInventory table fit into the whole picture? > > > I was actually led to thinking that the HouseholdInventory table is the same > as Main, and somehow the suggested fields in Table 8 have not been added to > it. But I do not think that is the case, as observed later on while creating > forms. I would appreciate if you can let me know if Im on the right track > here or failing to understand something. The HouseholdInventory table is obviously not related to the rest of the tables. It is not suppose to be related. A database file can contain tables which are related as well as tables which are not. One of the tables for this database file, Financial.odb, contains data of the person's physical possessions. The rest of the files contains the data of the person's income and expenses. All of them are a part of a person's net worth. > --Sowbhagya > --Dan
