Hi Guys,
Relatively inexperianced with access, so I just need a bit of help. I need to make an airport booking system with 3 tables, these are:
PERSONAL DETAILS(CustomerNumber, Title, First Name, Last Name, Address, Town, County, Postal code, Phone, Emails, DOB, Flying to)
FLIGHT DETAILS (Flight Number, Flying to, Flying from, Time leaving, Time arriving, Lengh of flight)
BOOKING DETAILS (Booking Number, Customer Number, Flight Number)
So I have relationships from PERSONAL DETAILS and FLIGHT DETAILS to the BOOKING DETAILS. I'm just a bit confused, is what I'm doing right? Are my relationships right? I also need to make a form with sub form, so what do I have to do there? THANKS PEOPLES FOR ALL YOUR HELP BEFOREHAND! I can send you my database if need be
Matthew