I have a large Access db and created all my tables that are normalized, created forms, reports, and queries. I used fake test data that consisted of 14 rows. Everything looked great until I appended REAL data that overwrote the 14 rows and added 50k more rows. The forms are not picking up this new data. If I manually enter each line item the forms pick up that information. I cannot manually enter 50k rows of data. Does anyone know how to get around this? Do I need to just hit submit 50k times so I get 50k lines and then do an update query?