Hi Peeps
Thanks for the help I've had so far with my project however I am stuck with sorting out the basic design for a particular part of the database.
Basically I have to keep track of international students staying in Rented accommodation. There will be approximatly 100 students at any one time.
The Homestays can change each year and obviously hold different amounts of students.
I know how it could be done, with a tbl for students, one for homestays and a Schedule one.
However I am really look for a very very simple way of tracking available property. The infomation needs to be a loose as possible because the students arent tracked as specfic as say the ones staying in halls due to the fact they dont have a contract with the institution.
I would really like a way of displaying a list of all active porperties and their status (i.e students staying) and have someway of updating via a subform. If anyone can point me in the direction of a similar designed db I would be grateful
Thanks for the help I've had so far with my project however I am stuck with sorting out the basic design for a particular part of the database.
Basically I have to keep track of international students staying in Rented accommodation. There will be approximatly 100 students at any one time.
The Homestays can change each year and obviously hold different amounts of students.
I know how it could be done, with a tbl for students, one for homestays and a Schedule one.
However I am really look for a very very simple way of tracking available property. The infomation needs to be a loose as possible because the students arent tracked as specfic as say the ones staying in halls due to the fact they dont have a contract with the institution.
I would really like a way of displaying a list of all active porperties and their status (i.e students staying) and have someway of updating via a subform. If anyone can point me in the direction of a similar designed db I would be grateful
