troubleshooting Question

Access Lookup issue - creating a new column to look up from a separate table

Avatar of Jase Alexander
Jase AlexanderFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
9 Comments2 Solutions182 ViewsLast Modified:
Hey guys

Hope you can help

I have quite a simple Access database that details shipments made to various countries against which are dates of shipments, reference, number of cartons etc.

The complete list of data is held in the Full data table. In addition to this, I have two other tables called DPD charges and Inhouse charge. The DPD charge is what the courier has charged for the delivery whereas the Inhouse charge is what the business has charged the customer for the delivery.

The issue im having is in creating a lookup in the Full Data table in the form of an extra column next to the Weight column on the right, that looks at the country in DPD charge table and return the relevant courier charge for that particular line.

For example, on the first line, in the DPD Charge column, the first row would return 9.87 as this would be the charge for deliveries to Austria. This is evident in the attachment after my unsuccessful lookup trial.

I would be extremely grateful for some help on this, I’ve tried using the lookup wizard by creating a relationship however, I cannot get a result to auto-populate? Is this possible? or would this only be a manual entry only situation?

Your suggestions would be very welcome - ive attached the database to see if you can give me some direction

J
EE.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros