Input in One Table Automatically Updates Related Field Information in Related Tables

[KMan]

Is it possible to have one master table in Access where if information is input there it will update all the other related records and fields in different tables? If not in Access, is it possible to do the same using Excel somehow? This would be for a database with probably about 15-20 different fields. To further clarify, think that I update a customer's address, phone number, and payment type in the "master table". Is it possible to then have all those changes made in any table where that same information is found?

[pbaldy]

In a relational database, you would normally only store the customer ID in those other tables. You'd get the address via a query that joined those other tables to the "master" table. That way, you only have to change it there.