Lab 2b

It looks like you didn't import all the Meeting records. There were ten of them in the file. But if your Pitch IDs were not numbered 000 thru 009, then some of the Meeting records couldn't find a Pitch record with a Pitch ID that matched their own so they failed to import. You can open MaxsMeetingDataFile in Excel and see the 10 Meeting records. You can see the Pitch ID for each one. When you open MaxsPitchDataFile you can see the Pitch records -- when they are imported they get P-000, P-001,... from top to bottom. But maybe you had trouble importing so your Pitch IDs are not those numbers? (000-009)

You can delete your Meeting records, then edit MaxsMeetingDataFile in Excel so each Meeting record has the Pitch ID of the Pitch record it is supposed to go with. Then save the file in Excel as a .csv file. The redo the import with the new MaxsMeetingDataFile.csv that you made. Then all the Meeting records show go in. (Each has to have the right Pitch ID to match up with.)