If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Setup
Hello All,
I am attempting to design an Access database that will track route scheduling. Basically what i am trying to do is allow a user choose a day of the week from a combo box and then autopopulate a subform with that day's route numbers and other information. Basically the each day of the week has numerous route numbers and other information such as route driver, vehicle number, route type that i am trying to display in a subform below a date and day heading. I want the user to be able to assign a route driver and a vehilce number to each route for the day. All the other info about the route wont change so i am hoping to be able to autopopulate that info. I have my route drivers and truck numbers in a lookup but i am haveing trouble determining the best and easiest way to get started. I am not sure how to set up each day with the route information linked to it so the user doenst have to populate the redundant route info each day. Any ideas? I am using Access 2007 and dont know too much about coding. Thanks for any help, Nate -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Form Setup
"nathank via AccessMonster.com" u6004@uwe wrote in message
news:a1f918f532d9b@uwe... Hello All, I am attempting to design an Access database that will track route scheduling. Basically what i am trying to do is allow a user choose a day of the week from a combo box and then autopopulate a subform with that day's route numbers and other information. Basically the each day of the week has numerous route numbers and other information such as route driver, vehicle number, route type that i am trying to display in a subform below a date and day heading. I want the user to be able to assign a route driver and a vehilce number to each route for the day. All the other info about the route wont change so i am hoping to be able to autopopulate that info. I have my route drivers and truck numbers in a lookup but i am haveing trouble determining the best and easiest way to get started. I am not sure how to set up each day with the route information linked to it so the user doenst have to populate the redundant route info each day. Any ideas? You shouldn't need much (if any) code for this but you don't say what you already have. Have you modelled the process into tables with relationships? Keith. www.keithwilby.co.uk |
#3
|
|||
|
|||
Form Setup
Yes, i have my tables all setup, i am just not sure if i did it correctly. I
have tblSchedule with lookups for drivers, vehicle number, city, etc... That is what I have so far. I am just not sure how to auto populate the subform. (wouldnt have to be a subform i suppose. i just thought that it would be the best way). Do i need to have a table for each day of the week with the route numbers, route day, city etc... for each day of the week so the form has somthing to populate from? I know that wednesday always has certain routes assigned to it and always in the same area of town and other info that is always the same. I am only wanting the user to have to choose the driver and the vehicle assigned to them that day from drop downs. Otherwise all info is the same each week. This is type of form is bacically what i am going for. Main Form Date Day of the week Subform Bob Adams Route 5 Vehicle #6 Area Dave Adams Route 6 Vehicle #3 Area I would want all the routes and their areas of town to be populated when the user chooses a day of the week from a dropdown. Hope this helps. Thanks again for any help. Keith Wilby wrote: Hello All, [quoted text clipped - 15 lines] set up each day with the route information linked to it so the user doenst have to populate the redundant route info each day. Any ideas? You shouldn't need much (if any) code for this but you don't say what you already have. Have you modelled the process into tables with relationships? Keith. www.keithwilby.co.uk -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Form Setup
"nathank via AccessMonster.com" u6004@uwe wrote in message
news:a201dc53e877e@uwe... Yes, i have my tables all setup, i am just not sure if i did it correctly. I have tblSchedule with lookups for drivers, vehicle number, city, etc... That is what I have so far. I am just not sure how to auto populate the subform. (wouldnt have to be a subform i suppose. i just thought that it would be the best way). Do i need to have a table for each day of the week with the route numbers, route day, city etc... for each day of the week so the form has somthing to populate from? I know that wednesday always has certain routes assigned to it and always in the same area of town and other info that is always the same. I am only wanting the user to have to choose the driver and the vehicle assigned to them that day from drop downs. Otherwise all info is the same each week. This is type of form is bacically what i am going for. Main Form Date Day of the week Subform Bob Adams Route 5 Vehicle #6 Area Dave Adams Route 6 Vehicle #3 Area I would want all the routes and their areas of town to be populated when the user chooses a day of the week from a dropdown. It looks like you have a one-to-many relationship: for each day of the week there are many routes. So you could have a main table "tblWeekDay" (for example) related to tblRoutes. tblWeekDay: ID DayName tblRoutes: ID WeekDayID DriverName RouteNumber VehicleNumber Area This is very simple and a bit restrictive. You might want to consider relationships between other entities in tblWeekDay. But in this simple example, if you have a form based on tblWeekDay and a sub-form based on tblRoutes then you should be able to handle the data the way you want. Sorry this is a bit rushed as I'm pushed for time at the moment, if that doesn't help then perhaps someone else can jump in. Regards, Keith. |
#5
|
|||
|
|||
Form Setup
Thanks for the help Keith.
I see what you are saying here but i am still not sure about the autopopluate part. Thanks Nate Keith Wilby wrote: Yes, i have my tables all setup, i am just not sure if i did it correctly. I [quoted text clipped - 28 lines] the user chooses a day of the week from a dropdown. It looks like you have a one-to-many relationship: for each day of the week there are many routes. So you could have a main table "tblWeekDay" (for example) related to tblRoutes. tblWeekDay: ID DayName tblRoutes: ID WeekDayID DriverName RouteNumber VehicleNumber Area This is very simple and a bit restrictive. You might want to consider relationships between other entities in tblWeekDay. But in this simple example, if you have a form based on tblWeekDay and a sub-form based on tblRoutes then you should be able to handle the data the way you want. Sorry this is a bit rushed as I'm pushed for time at the moment, if that doesn't help then perhaps someone else can jump in. Regards, Keith. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|