it's difficult to say without knowing more. One thing I can see from what you said is that you're using Name as a key field. This is a very bad idea and may be the source of the problem. Names change. It would be likely there would be two Bill Smiths over a, let's say, five year period. It seems at first glance your main table should be student Names. Perhaps the other table should be Trips. A permission form doesn't seem to need its own table and if it does it should be a third table.
This would work to have 3 tables. Thank you!