G
Guest
Hi
I am creating a database to track drivers of vehicles. The drivers will be
identified by the vehicle they are seen driving.
I am using three tables:
vehicle details (VEHICLE ID is the key)
driver names and information (DRIVER ID is the key)
Known characteristics of each driver. There is a fixed list of 19
characteristics, any or all of which may be assigned to each driver (CHAR ID
is the key)
Each vehicle can have multiple drivers, and each driver can drive multiple
vehicles, so I have set up a many to many relationship using a junction table.
Each driver can have one or multiple characteristics and each characteristic
can belong to many drivers, so I have set up another many to many
relationship using another junction table.
I am displaying vehicle information on a single form, within which there is
a continous subform to show drivers plus their information for that
particular vehicle. I need to be able to show the known characteristics for
each driver of the vehicle on the same screen display. Access does not allow
me to display "driver characteristics" as a continous subform within the
driver information subform as you cannot have a subform within a continuous
form. In terms of presentation of the form, I need to keep the "driver
characteristics" listed exactly next to each driver. Once there are lots of
drivers associated with each vehicle, if scroll bars appear, when you scroll
down the list I need the driver characteristics to scroll too to show
relevant information. I therefore assume the driver info and characteristics
need to be on the same form.
How can I get around this? Can I use some sort of query? Or do I need to
somehow list the driver characteristics within the driver information table?
(I'm not sure how to do this as I thought that a separate many to many
relationship was needed because up to 19 characteristics may be associated
woth each driver, and these may change over time.)
Looking forward to your advice and expertise.
Thanks
Rich
I am creating a database to track drivers of vehicles. The drivers will be
identified by the vehicle they are seen driving.
I am using three tables:
vehicle details (VEHICLE ID is the key)
driver names and information (DRIVER ID is the key)
Known characteristics of each driver. There is a fixed list of 19
characteristics, any or all of which may be assigned to each driver (CHAR ID
is the key)
Each vehicle can have multiple drivers, and each driver can drive multiple
vehicles, so I have set up a many to many relationship using a junction table.
Each driver can have one or multiple characteristics and each characteristic
can belong to many drivers, so I have set up another many to many
relationship using another junction table.
I am displaying vehicle information on a single form, within which there is
a continous subform to show drivers plus their information for that
particular vehicle. I need to be able to show the known characteristics for
each driver of the vehicle on the same screen display. Access does not allow
me to display "driver characteristics" as a continous subform within the
driver information subform as you cannot have a subform within a continuous
form. In terms of presentation of the form, I need to keep the "driver
characteristics" listed exactly next to each driver. Once there are lots of
drivers associated with each vehicle, if scroll bars appear, when you scroll
down the list I need the driver characteristics to scroll too to show
relevant information. I therefore assume the driver info and characteristics
need to be on the same form.
How can I get around this? Can I use some sort of query? Or do I need to
somehow list the driver characteristics within the driver information table?
(I'm not sure how to do this as I thought that a separate many to many
relationship was needed because up to 19 characteristics may be associated
woth each driver, and these may change over time.)
Looking forward to your advice and expertise.
Thanks
Rich