Search results

i got tblAccommodation, wit Accomm_id(AutoNumber), Description(Text), Self Catering(Yes/No), Hotel(Yes/No) attributes. Also i got 2 tables for tblSelf Catering wit Accomm_id(Number) and tblHotel Accomm_id(Number), Board(Lookup Wizard[Bed n Breakfast, Half, full board]). so diagram looks like...

relationships relationship Customer(customerid, name, address, age, tel#, gender) Booking(book#, customerid, start, end, party, cost) SelfCatering(accomm id) Hotel(accomm id, board) AccommBook(book#, accomm id, start, end, cost) Season(title, start, end) Available(title, accomm id, price)...

errrmmmm......................... i got the relationship diagram and when i implemented the tbales with relatioship i doesnt do what it supposed to do.

i build the database but cozing problems please help any one. i can email database file to have a look at.

i have pm you please add me

i need help with doing relationship in Access. i have created the table but, the tables consists of compound, composit and candidate keys and i am getting stuck how to do the realationship. i have the EER diagram of how it should join with the attributes. you can add me on msn zahir56@hotmail.com