Search results

I am not sure if my relationships are linked correctly... customer id [customer table] - customer id [booking table] room id [booking table] - room id [rooms tables] room id [rooms tables] - room id [cleaners table] room id [rooms tables] - hotel facility id [hotel facility table] room id...

thanks :D

Im tryin 2 create a relationship between to of my tables and da folowing error message keeps appearing: no unique index for the referenced field of the primary table wha does this mean? :confused:

That has helped, i deleted the orphan records and im able to enforce referential entegrity and now have one to many links between my tables etc Thanks

I am designing a database for a hotel booking system for my A level project... The following are my entities and attributes... customers table - Customer ID, title, firstname, surname, address, town, postcode, county, dob, sex, telephone, mobile bookings table - Booking ID, Customer ID...