I don't know if I what I want to do can be done. It seems simple but maybe it's not just part of the program. I'm VERY VERY new to this so please if you have a solution put it in layman's terms as I am still familiarizing myself with the layout and terminology associated with the program.
To best explain what I'm trying to do I'm going to simplify it using a sports analogy.
Every Baseball team is part of a league and part of a division in that league.
When Setting up a table I would like to have Access auto fill some of my fields based on what is put in another field. For Example. If I type "Braves" in my team field, I would want it to auto fill League with "National" and Division with "East" Ideally if I had multiple tables, I would like then all to do the same, so if at any point I have a team field on any table it would fill in the rest the same way. Is this option available to me? Any help would be most appreciated.
Thanks in advance.