a little stuck

[GetReel]

Im trying create a DB to book in tenants into our houses. I need to be able to do reports on who is currently in the houses and who have been booked. So effectively a house can have many tenants and bookings.

the booking form should enable a user to select a tenant from the tenant table and add the date when the are expect to be occupy the house. Naturally a person cannot be added if a tenant has already been booked for the same date.

I image i will need tenant table, house table and a booking table.

Does anyone have any suggestion who I would go about doing this or has anyone have a similar DB that they would like to share.

 

[Rich]

There have been several Hotel Booking examples posted here, you should find one to suit

 

[GetReel]

Thanks..I'll do a search.