Anyone willing to help me design a database?

[daherb]

Your still not thinking through exactly how things need to work, why would you need to provide passengers with a flight time after they have made the booking, the system would provide this when the booking is made.

You need to sit down and think about exactly what the clerk would do when taking the booking and what the system would need to do in order to facilitate this.

 

[accessistough]

The clerk needs to take down the name (forename & surname), the date the customer wishes to fly and obviously he/she is going to have to enter where the customer wants to be going (and where they are flying from) Looking at my 'tblpassengers' im not sure it is complete.

I only have, Surname, Forename, DateBooked (which will fill in today's date automatically) and DateFlying.

As of yet I have nowhere to store where the passenger wants to travel to, and where the passenger is coming from...

Do you agree or have I got it all wrong?

Thanks.

 

[ScottGem]

I disagree with Daherb here. A passenger is a customer, customers come back to order again. So you want to check to see if the passenger has flown before. If not, then you use the NotInList event to add a new passenger.

The AS Fullname in the SQL stmt sets the name for the calculated column. Each column has to have a name.

There is no need, IMHO, to store where the passenger is originating and going. In my suggestion you use UNBOUND controls to enter that info. They are used to filter the list of flights. Once a booking record is created, that will store the ScheduleID whihc tells you that info.

 

[accessistough]

Thanks for clearing that up ScottGem. Still when I enter that SQL statement it only lists the numbers from the autonumber 'PassengerID' field instead of the passengers name.

If I try to select one of these numbers a quick error message pops up on the bottom left explaining I can't edit the autonumber field.

 

[ScottGem]

The first problem is you didn't use the wizard propelry to create the combo. Otherwise it would have set the column count and column widths properly. The Column Widths property allows you to suppress display of columns by setting the width of the column to 0". A Combobox only displays the first non zero width column. That's why I combine the surname and forename so that both are displayed.

The reason for the error message is that you have the form bound to the wrong table. I told you to bind it to tblBookings, not tblPassenger. The combo should be bound to the PassengerID in that table.

 

[accessistough]

Yeah, I bound it to the wrong table by mistake. Sorry about that. Its listing the names in the passenger table as it should be doing now.



How would I go about filtering flights from what dates and locations have been put into these boxes I have made?

Thanks.

 

[ScottGem]

Same way you would filter any query. Set the criteria in the query to reference the controls on the form using the syntax:

Forms!formname!controlname

 

[accessistough]

Hey, Im just about done with this now...

One quick question... Ive got some text boxes in a form. When I enter a value into one of them I want the value to go into a table... I know its simple but I just cane figure out how to do it.

i can use the wizard but ive already got my form all set up... and it wont let me cut and paste the text box from one form to another... can the expression builder be used to do this someway?

thanks.

 

[ScottGem]

Is the form bound? Is the control bound?

 

[accessistough]

Im not sure. I think the form is bound. I tried making the control in a seperate wizard and drag it in but it wouldnt let me. Please could you take a look for me if its not too much trouble?

Its the 'frmaddbooking' the tab at the top to flight details, and what I want the textbox next to destination to do is to put the number that i enter into it, into 'scheduleID' in 'tblbookings'.

If you could help me with this I would be very grateful.