My AutoLookup query isn't filling in data.

For AutoLookup to work, the joined fields must meet certain conditions, and you must include certain fields from both tables in the query design grid. For more information, click .