I have 2 tables, Customers and Lates. I want to populate data ONTO Late FROM Customers. The match field is done correctly – it’s the primary on the Customers table and a MANY on Lates. The QUERY works fine. Like the Access documentation shows, the information from the “source table” (Customers) shows up perfectly on the DYNASET – the results of the query. BUT – the SAME fields on the ACTUAL table – LATES – remain blank. I need the results of the query to actually FILL the second table! The Access documentation and screen shots make it seem as though the TABLE is getting filled with data from the source table but this isn’t what happens – only a query dynaset happens. Do I need a Macro or something. I shouldn’t have to do look ups or Macros because according to Access Help – the “Query automatically fills in data.”
