Moving fields from one table to another table in the same database
I have created a database (student Information) with approximately 100 fields. I then created a new layout (Performance Levels) and added another 80 fields. I also added a third layout (Goals) and added another 100 fields to this layout. I then went to Manage the database to create relationships in the tables. My first table (Student Information) shows it has 280 fields, my second table (Performance Levels) has 0 fields, my third table (Goals) also has 0 fields. Is there a way to move some of the fields from the student Information table to the Performance Levels table and to the Goals tables?