Creating a Project

[HLMack]

I am new to Access and would like to get some answers to get me started. I
want to design a project for my truck that would include a Daily Trip Log, a
Expense Log, and a Stops Log. Should I set up 3 tables and if so how would I
link them? Can I show all data on 1 form or will I have to use sub-forms? The
log could have no stops en-route for short runs or many stops depending on
the length of the run. As such it may or may not have expenses. I envision it
to look something like this:
Trip Log
Date
Depart from, city, state, zip, beginning mileage, and time.
Arrive at city, state, zip, ending mileage, and time.

Stops Log
Reason, arrival time, mileage, place stopped, and depart time.

Expense Log
Type expense (diesel, food, showers, etc.)
Expense cost

From this I should be able to caculate expenses, mileage, hours driven, etc.

Thank you.

 

[Steve]

I suggest the following tables:
TblCityStateZip
CityStateZipID
City
State
Zip

TblTrip
TripID
TripDescription (purpose??)
DepartDate
DepartTime
DepartCityStateZipID
DepartMileage
ArriveDate
ArriveTime
ArriveCityStateZipID
ArriveMileage

TblStopReason
StopReasinID
StopReason

TblTripStop
TripStopID
TripID
StopReasonID
ArriveDate
ArriveTime
ArriveCityStateZipID
StopLocation
ArriveMileage
DepartDate
DepartTime

TblExpense
ExpenseID
Expense

TblTripExpense
TripExpenseID
TripID
ExpenseDate
ExpenseTime
ExpenseCityStateZipID
ExpenseLocation

TblTripExpenseDetail
TripExpenseDetailID
TripExpenseID
ExpenseID
ExpenseAmount

1. Use a form to enter the data in TblCityStateZip
2. Use a form to enter the data in TblStopReason
3. Use a form to enter the data in TblExpense
4. Use a form/subform to enter data in TblTrip and TblTripStop. Set up the
main form to enter data in TblTrip and set up the subform to enter data in
TblTripStop
5. Use a form/subform to enter data in TblTripExpense and
TblTripExpenseDetail. Set up the main form to enter data in TblTripExpense
and set up the subform to enter data in TblTripExpenseDetail