Auto filling a form from table

[JoScSM]

I have attached a copy of what I am working with. I am trying to make a form that when I enter an invoice number it will populate. Veh Year, Make Model, Color, Plate, VIN from the LeTowing Table. but it will also have to use all of the fields from CarSales Table. I am a new to access, HELP

[NTC]

Sorry I don't do attachments.

To design a database, one must have a textbook - easily found at Amazon or any big bookstore.

A form, bound on a table or query, can use a combo or listbox in the header to find the record selected. This is a standard feature of Access and you will find examples of this in any textbook.