Please forgive me for being a noob. I have been roped into creating a new database for a courier service and this is not really an area of expertise for me.
This is a pretty basic database in Access 07. Four tables, customers, price_list, employees, and deliveries.
CompanyID (primary key)
Employee ID (primary key)
From (Primary key)
Bill To (foreign key to companyID)
Driver (foreign key to employeeID)
From (foreign key to "from" in price_list)
I have set up a basic form to enter data into the deliveries table, but what I would like is to be able to choose the delivery from a drop down box on the "from" field, and automatically fill the to and price rows with the corresponding rows from the price_list table. I hope that makes sense.
Again, I apologize if this is a stupid question, or if it has been covered before.