I am working on an invoicing database. I have three 1.po, 2.line Item, and 3.Vendor. When I try to use a dropdown list for Vendor name it will not work. if I use a combination of Vendor code and Vendor name the dropdown works but it wrecks the report in the line item database. the new po's show up but the names no longer do they new po's all show up under one vendor. however if I look at the records individually the show the proper vendor names?:?::?:?????? SOMEBODY HELP PLEASEE!!!!