September 9, 2009 at 4:53 am
Hi, i'm developing a database to store car accidents information.
One of these information is about the type of crash : i have 4 main categories ("moving vehicle", "vehivle vs pedestrian", "vehicle vs fixed obstacle","other") each one with its own item (i.e. for moving vehicle i have "front crash", "side crash","back crash").
Both (main category or detail) could be used as report parameter (one may choose to report all car accident for "moving vehicle" category or just for "front crash" car accident).
Now, my question is : it is better to store this classification in two lookup tables (one for main categories and one for details) or just have one table with both information ?
I decided to use the latter solution, but i'd like to know your opinion.
I use the main category field to fill a dropdownlist in my form; when the user select an option, i fill a second ddl with the details , then I store the ID of the latter selection in the Accident table (foreign key).
September 9, 2009 at 10:58 am
September 10, 2009 at 12:19 am
Thanks.
June 10, 2022 at 6:50 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply