I need help with an Access Database. I have reached a point where I am stuck!! I need a couple of queries and an update table query but cannot get it to work.
The database is for a small language school that brings kids from around the world to stay with local families to improve their English. The database includes details of the children and the 'host families'. The database would work in the same way as hotel reservation system.
So far I have the structure of the database that I need but I need a query that will show me which accomodation is available, the to book the accomodation in a table. I also need to check that all children have accomodation allocated. I have attached a copy of the relationships so you can see what I am doing!!