From your description, I don't think the problem is the value list itself. I think you're using a related field for Table B. When the Company field is populated, it's reflecting the first matching value in Table B because it's showing the field from Table B instead of the field in the current table, which is (I think) what you want. If you have an appropriate field in the current table (say, "Staff Member"), then you should be able to attach your value list to it and it won't populate until the user inputs a value.
From a relational standpoint, I would have to ask: Do you want to duplicate the data from Tables A and B into the current record? Because there are likely better ways to model this.
Thank you so much. I’m very “green” when it comes to database setup - Your feedback was very helpful. I was using the wrong field on my layout – a simple change made everything work great!
Interstate Connecting Components, Inc.
120 Mount Holly Bypass
Lumberton, NJ 08048
Tel. (856) 813-5411 | Fax. (856) 813-5469