I have a database with several tables. All the tables are associated and related to each other by their CustomerID. My primary table has CustomerID information and CustomerName information included. I would like the CustomerName to default to each table so it will pull in on the reports I create. Any thoughts?