I am trying to use Access to organize company files.

I have a main table called LOGBOOK, it contains all the information, like ID, customer name, etc.

And I have another 10 tables, which are customer tables, the name is their company name.

I want to set up an autofill, which means when I enter a new ID and customer name in LOGBOOK, all information can automatically fill in another table based on the customer name.