Hi Everyone
Im having a slight issue with exactly how im going to approach this so i thought i would throw it out and see if people have ideas.
Im building a system for a care home, they have rooms that have certain attributes like being en-suite or being a double or single room. With that in mind i made a table (tbl_rooms) with the fields that i needed. Now im tring to get a way of allowing the user to choose what room goes with what resident. So i created a subform, put a relationship in as tbl_resident.RiesidentID to tbl_rooms.residentnumber and then thought that if the user chooses the room number from the drop down list (tbl_rooms.RoomNumber) then the rest of the information would populate. However its actually creating a new record. (Hope this makes sence :S)
How would you design this to work?
Thanks in advance
Chelcone