Richard, I have a problem building my database for my finance's new business.  I soon realized after creating some queries, forms and and reports that at least one or more of my tables were carrying way too many fields so I split them into two or more tables to that each table would be more streamlined in their purpose.  But as you can guess, after I did that, I broke the linkage to almost all of my forms, queries, and reports.  Is there an easy way to restore the links to a database field's new table location without rebuilding the forms, queries, reports from scratch again.  If it is easier to point me in the direction of a training video, that would be just fine too.

---

Reply from Alex Hedley:

If the Field names are still the same you could join the Tables in a Query and then update your Form's RecordSource and the Controls on the Form should still work.