Also, it seems to be having some trouble with my flight numers (EG1642 for example). Saying they are too complicated and to split it up using variables??
accessistough said:Flight Number was the primary key. Ok, gonna have to have a look at some code I guess...
ScottGem said:Also its not clear what is the join to tblAircraftInfo. Is it FlightID or ScheduleID?
accessistough said:Also, a quick question. Why is it important that spaces are removed from field titles and such? I have removed them as suggested but am curious to know the reason behind the importance of leaving out spaces.
Thanks again.
ScottGem said:Getting there. You need to add another instance of tblAirports and link that to DestinationID. I would just use Departing as the field name. Definitely not use DepartureDate&Time as the & is a special character. I'm not sure what TripID is either. the relation from FlightSchedule to tblBookings should be ScheduleID not FlightIDthe relation from AircraftInfo to FlightSchedule should be FlightID. Remember, you generally go from PK to FK.