Recent content by spids101

Thanks David for your reply. I understand what you are saying a bit better, should be able to accomplish this. Is there anything I can do if there are multiple rooms available in an apartment? Or would I have to create separate entries like this: apart101 room1, apart101 room2, apart101 room3...

Thanks Ranman for your reply. It has been some help but still not entirely sure how to get this to work. I only had a student details table and apartment details table. So create a query and link through the ids? Would they be manually typed into field in the student table?

Hello Access Programmers, I need bit guidance with my database. I have 2 tables, one with student details and the other with apartment details. I would like to set it up so that a student can be easily assigned an apartment and when the apartment is available it can be seen in the database...

Awesome got it working :) Thanks so much

Thanks guys I will try your advice

Hello there, Been lurking around the forum for while now and glad I found it. Its been great help for creating my database, thanks so much. I have run into some problems though. I have one main table where all the details of users are imported, I have created several queries for different...