Search results

Ive Done It!

If you look at the new db I have a llink table between flight and seat that links to the booking. Check it out. that table shows every seat for every flight, i make it using the append query and entering the flight number. Check it out, if you can get that table to display the data it has in it...

I have attached the new database. I have been working on a few things, like assigning staff to a crew number, so that a crew can be applied to flight. I think I have done it correctly, but was just wondering if you thougt so too. And also, I have the same problem with BOOKED query. IT only shows...

hey rural, hows the union query going?

I have also been playin around. I ran an append query on the list of seats query, and appended them to the seat flight table. Then I could run that from a button each time a flight is added. And I dont need the records updatebale right away I dont think no. ANdi.

It needs to be able to display all the seats for a given flight, with ones that havent been taken and ones that have. And then I can use it as a subform for the booking form, and add in a booking into the slot that is available. Then the next time I run the display it, shows that the new booking...

Rural, here is the new db with the link included. It means that seats can be booked for multiple flights. Usefull indeed. But I am not sure, on how to create the query so that it can show taken and not taken seats for a flight, same problem as the beggining. I think once I can display that, I...

Okay, so that is good because it lets me book a seat more than once, which is exactly what I needed to do. But now, what parameters do I need in a query to show not only the seats on a flight that have a booking, but also the ones that dont....?

I tried that last night and it didnt work, becuase you cannot then display te details of all the available seats :(

lol I wish I hadnt got myself into this mess. Is there any recommendations on building it differently if I go for it a second time around. So that seats can be booked for multiple flights. Andi.

Thankyou. THere is no way it should be this hard to do it, I was up untill 2.30am yesterday, and still wasnt getting anywhere. Been on it all morning now aswell. It's a case of, once the seat ID has been booked in for a flight, it's like the flight has stolen the seat ID and keeps it. I cant...

hey ruralguy, CAn you look at that problem, because it means that the whole idea doesnt work. The database you queried, it displays all the seats yeah, but once a seat is booked for one flight, it is not availble for any others. I dont understand why, as when a boking is made, a flight ID is...

I tried it that way because I couldnt get the seat to be available for other flights once it had been booked for one. So like if I booked seat Id 6 for flight 1, seat ID 6 was not available for flight 2. Is there any way around this, ignore the database I just posted. I am refereing to the one...

got to this now. Changed things around, but now am having the double booking problem rather than just one booking for each seat. Also I have added in the plane ID too so tht differnt seating plans can be done. The new query query1 will show you the problem. Any ideas on where I am going wrong...

I have discovered a fundemental flaw in the system. If you run your query again, and look at flight ID 1, there is a booking for seat ID 5. If you then run the query for any other flight, the seat ID 5 has disappeared. Any sugggestions why? Andi

so I would need say, row a-G on plane ID 1, with seats Id's to 59, then rows A-G on plane id 2, with seat ID 60 to 150 say??

Not sure I know what you mean there. I made the above, but it just exchanged the seat Id to Seating plan. Not sure if that is the way to go about it, maybe I just set it up wrong. maybe a link table with seatingplanID, plane ID? Not too sure, little lost again.. could create an identical table...

seating plan as PK, seat ID, seat row, class ID and plane ID??

Thankyou so much, by the looks of things, that is exactly what I was looking for. It's the IsNull one I didnt know how to do, even though I knew that was what I needed. Your a star, ill just change the 1 in criteria now to [Enter Flight Number] and it'll be perfect, meaning the user can enter...

lmao well it seems my spelling is worse than my problem solving skills. thankyou for pointing that one out anyhow, an embarrising mistake to leave in there... haha. Well, it has taken me a while to get a seat not to be booked on two flights, I did initally want a different seating plan for...