I have a repair database with two tables not related. One contains all of
the invoices for repairs based on truck number invoice number and date.
The other table contains the driver name truck number and the date range
that driver drove that truck. I have added a new field to the invoice
table called driver. I need to attach the invoices to a driver base on the
truck they drove and the date of the invoice. I am totally stumped as to
how to proceed. Any help would be greatly appreciated. Thanks in advance.