I'm a big fan of your videos. They are very easy to follow and understand.
I am looking for a way to enter a new record into one table with information automatically entered from another table. I see in your sample database that you have a Customer List Form in which you can click on a record there and it will open up the Customer Details Form with just that record's information.
I would like to use a similar Customer List Form, but instead of opening a Customer Details Form, it opens up a Job Form to Add NEW RECORD, and will automatically fill in the Customer ID Field so I don't have to choose from a drop-down combo box. I have a very large customer list and that would be very cumbersome to scroll down. It would also prevent errors from choosing the wrong customer. Any tips?