I am managing a project and have multiple spreadsheets (originally in Excel that were imported into Access) all of which share a common field. How do I set up a relationship between all the spreadsheets so as to ensure that if I update a common field in one spreadsheet it will automatically update the same field in all the other spreadsheets? I assume there is a way to do this and that not every database is based strictly on one super huge spreadsheet with hundreds of columns. I'm so frustrated with this. Please help! Thanks!!!