Punctuating the dates properly will work. If you have something that works now and are pressed for time, I would advise to keep on this path for now, but eventually you might find something profitable in getting rid of the form and instead using the power of SQL to associate data from two different records that have some factor in common. This might take exploration and I don't want to delay you with your project. But if you are ready to look at this, do some reading and come back with questions.
The issue I suggested with a JOIN can best be understood by looking for topics using the SEARCH function of this forum. You can look for JOIN, INNER JOIN, OUTER JOIN, LEFT JOIN, or RIGHT JOIN (one of those at a time) for reading.