Cottage rental problem

[Garmin]

I've created a database consisting of 10 tables in total (see image).

I've had no problems constructing the database, however when I come to create a booking form I came across a problem. If I add in payment details into the booking form, it won't show records or let me add one, if I take payment details out it works fine.

This makes me think there is possibly a problem with how I have linked the customer and payment tables together but having problems seeing where I am going wrong, could anyone offer a little help?

 

[Rickster57]

bookings

Looks to me like your tblbookings needs to be related to your tblpayments by bookingid

 

[johncallaghan]

this is because you have one to many relationship with payments and each cottage. You can get over this by putting the payments on a form and adding this as a subform on your cottage form.