I am creating a database for automobile expenses. I have tables
for fuel, maintenance, and vacations. All require at least one
odometer reading so I have created a fourth table for that with two
fields: the primary key, and the reading.
The fuel table contains a primary key and the following keys:
Cost, CostperUnit, BeginReading, and EndingReading. What I want to do
is to create a form in which Fuel is the main form, and Odometer is
the subform. I also want a 1:1 link between EndingReading and Reading
of the Odometer table. And I want to make BeginReading a listbox for
the Reading field of the Odometer table. This way I only have to
enter the odometer reading once. The list will have the beginning
reading.
How can I accomplish this? I have created a 1:1 relationship
between the primary keys of the Fuel and Odometer tables. Is there
another way to do this?
I am subscribed to this mailing list, so I do not need to be
CC'd.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
