 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2007Creating a Project
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. 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 >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, [quoted text clipped - 23 lines] > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.