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?
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?
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.
--Sowbhagya
