I manage 20 facilities for a non-profit agency. I want a database that tracks a variety of information for the facilities, so I want different and various tables for each kind of data (supervisors of each facility, utility providers of each facility, fire equipment located at each facility, etc.) I have a table that contains the cost center code (a unique number field), which is my primary index, and the facility description (a unique alpha field.) I want all of the other tables to contain these two fields, and if a change is made to a record in either of these fields in the main table, I would like that change to be reflected in the other tables. I have tried linking them in the relationships window, but that doesn't yield the desired effect. How do I do this?