Is it possible to set up a table within a base that would duplicate the primary field of another table and that would automatically edit in tandem with that field in the other table? For example:
Say I am creating a database of countries. My first table is a list of all of those countries, populations, info about them, etc. Next I want to create an additional table that specifically focuses on proposals related to those countries. How can I assure that if I make an addition to my country name field on one table, it is also added to the other table? Thanks!