Display name instead of number

[ferociousllama]

I'm having a problem with my database. I have an "invoice" table and a "vendor" table. The vendor table has two fields, a vendor number and vendor name. The invoice table looks up the vendor number but displays the vendor name.

I created a query to show me all outstanding invoices. The query displays the vendor name properly. I then wrote VBA to send an email to people listed as "contacts" for each invoice. The problem I'm having is when I try to use the Vendor name in the body of the email it only shows the vendor number.

Can this be done?

You all are the very best and I am greatly appreciative of your assistance!

 

[pbaldy]

You're running into this I suspect:

http://access.mvps.org/access/lookupfields.htm

You can include both tables in your query, joined on the number field, and return the name field.