Unless I'm misunderstanding your answer, I think my tables actually do match the first example you gave - one table contains Serial Number and Location (i.e. inventory), the other contains Serial Number and Date Used (i.e. each line contains 1 date and 1 serial number)
So, how do I do a 1-to-many match? I've already created 1-to-many relationships among the tables using serial number - I'm just missing the last step of joining. I've tried joining once before, and just got a drop down box, which is not what I want. I want a result with all records listed and the field fully populated.
Thank you for your help...
Thanks - I've already created the relationship. I want to merge the tables so that I end up with one table that has all fields (Serial Number, Date Used, and Location).
When I run a query, I'm able to get a result that has those fields but has only drop down boxes instead of populated fields in a table. I don't want to use this for look-up, I want a summary table that I can run data analytics from. What am I doing wrong?