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.
Customers:
CompanyID (primary key)
Company Name
Address
Contact
Employee:
Employee ID (primary key)
Name
Address
Price list:
From (Primary key)
To
Price
Deliveries
DeliveryID
Bill To (foreign key to companyID)
Account#
Date
Driver (foreign key to employeeID)
From (foreign key to "from" in price_list)
To
Price
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.