Novice: Can't get simple lookup working on related table
I set up (2) Tables: COMPANIES & PEOPLE (each with 2 records-- 2 people and 2 companies
In COMPANIES I set up Company (name) and Location (for multiple location companies)
In PEOPLE I set up personal info plus Company and Location in a drop down list from COMPANIES
In PEOPLE the 2 records work fine. A drop down list appears with both company names.
But when I attempt to add a new record to PEOPLE, the Company field does not respond in any way.
I'm sure this is a function of my ignorance, but I can't find a solution. Going mad!