| re: make database
"Michel" <michelparadys@yahoo.ca> wrote in message
news:pqIbg.79844$oX5.1178809@wagner.videotron.net. ..[color=blue]
> Hi Jerry,
>
> The database may be fairly simple. For a start, one table would be enough.
>
> Table: CarMaintenance
> FIELDS:
> MaintenanceDate (primary key)
> Mileage
> Garage
> Cost
> PeriodicMaintenanceType
> Trouble description (memo field)
> Work description (memo field)
>
> But you could make it a lot more complex.
>
> For example, you could create tables describing the various periodic
> maintenance types:
>
> TABLE:
> PeriodicMaintenanceTypes (alias Pmt)
> For example:
> Pmt1 is base periodic maintenance and includes oil change + 5 checks,
> Pmt2 is intermediate periodic maintenance and includes oil chage + 25
> checks
> FIELDS:
> PmtCode (primary key)
> PmtDescription (text field)
>
> TABLE:
> Checks
> lists checks that can be included in one or mare periodic maintenance type
> FIELDS:
> CheckCode (primary key)
> CheckDescription (text field)
>
> TABLE: PmtChecks
> relates tables Pmt to Checks
> FIELDS: (all in primary key)
> PmtCode
> CheckCode
>
> Now include in CarMaintenance reference to Pmt table by replacing field
> PeriodicMaintenanceType by PmtCode.
> Then, using Tools menu, establish relations between the tables to ensure
> integrity:
>
> CarMaintenance (PmtCode) --> PeriodicMaintenanceType (PmtCode)
> PeriodicMaintenanceType (PmtCode --> PmtChecks (PmtCode)
> Checks (CheckCode) --> PmtChecks (CheckCode)
>
> Have fun!
>
> "Jerry" <notmyspam@houston.rr.com> a écrit dans le message de news:
> PTrbg.46902$CH2.2508@tornado.texas.rr.com...[color=green]
>> Hopefully this is the right group to ask. I am new to databases and I
>> want
>> to build a database to record maintenance for my car to learn with. I[/color]
> would[color=green]
>> appreciate any suggestions for fields to use for information I should
>> capture and should I make multiple tables or just one? Information[/color]
> pointing[color=green]
>> me in a direction of ideas would be appreciated.
>>
>> Thanks.
>>
>>[/color]
>
>[/color]
Ok, I am having fun. But not a lot of success. I could not find a template
that looked useful so I am starting from scratch. What I have so far is
something like this:
Table: Maintenance
ServicedBy
ServiceDate
WorkPerformed
Odometer
PartsUsed
Parts Cost
What I am thinking is I would like to list the parts individually and the
cost of each part used if more than one at time of service instead of a lump
of them in the same field. Make sense?
Thanks
| 
