My DLookUp field will not populate the field in my table or on my report. For example:
My field is called Suppliers and it looks up the Supplier Name by Supplier ID.
My table has a field called Suppliers, but the information that is "looked up" does not fill in the fields in my table, nor on my report.