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
