Your database is not normalized properly. There should never be this kind of duplication in data. A much better model would look like this.
carId (foreign key to dbo.Car)
Now when you insert data, you only insert it in one place and data integrity is maintained automatically.
When you want record data for a car the query is simple.
INNER JOIN Record ON Record.CarId = Car.Id