How to get this working...

[mdixson]

Right below is my ERD and i need to get it so a seat is reserved for a customer, anyone got any ideas how?

here is the image link: http://img.photobucket.com/albums/v205/mdixson/ERD.jpg

 

[mdixson]

problem is that the seatID is an auto-number and i need to be able to search seats on flights; and thats were i'm stumped