Yes stick with Customer from now on, ignore anything to do with stock as posted previously

When (or if) I sort this out I will go back to the stock table at a later date...this is the same issue. Im just going right back to the beginning.

The BookingsID is the primary key field in bookings table.
The CustomerID is the primary key field in the customers table.

CustomerID will be a foreign key in bookingstable. I think I got that right.

Customer
CustomerID (pk)
CustomerName
CustomerAddress

Bookings
BookingsID (pk)
CustomerID