Hi,
I have want to build a database with car parts. The problem is that the car part can fit the car but from year 2000-2004 and not only just one year like 2001.
For example:
Make Model Part Year
Toyota Camry Mirror 2000-2004
The thing is that the mirror fits the car from year 2000-2004. But I want in my application to select year maybe 2002 and want the same part to show up.
Jump to PostMaybe create YearBegin column and YearEnd Column, then in the application perform the logic to figure out that 2002 is within 2000 (Begin) and 2004 (end).
Maybe create YearBegin column and YearEnd Column, then in the application perform the logic to figure out that 2002 is within 2000 (Begin) and 2004 (end).
In addition to JorgeM: make the from and to a date column, so if needed, you can store day and month too. No car part is built an entire year exactly.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.