Need help about pre filled form

[Exotic]

Currently, I am trying to create database for my apartment. Every month, I need to fill in the form for update my invoice Table for every room of my apartment. For example, suppose I have 100 rooms and I need to fill in the room number , electricity also water bill for each record. however, I do need to type 100 room numbers every month which I feel like it s not necessary to do that. Can I just let the access filled all the room number for me and I just fill the water and electricity bill ? Thank you for your suggestion

 

[Bryan]

You should probably do a bit of reading on normalizing databases. Your situation calls for a one to many relationship between a table that has a record for each of your rooms and a table that contains the records pertaining to each room.

With this relationship, you should be able to devise a way to avoid entering the room number each time.

 

[Exotic]

Thank Bryan but I Think I did that already I have create two table the first one is for room which include the detail of the room and the room id. Another table includes the room id which is related with the first table and detail about invoice. However, when I create a form to update the invoice table I still need to insert room Id for every month. In my opinion I think this is not necessary because I know that I have to insert the new records for invoice table for every room every month so it would be good to have prefilled form for the room id. Thank you

 

[Bryan]

Ok. Tables sound right.

To avoid entering the room number on your expense entry form, you can use a combo control that looks up and allows you to select the room number. Go through the wizard and have it look up the room numbers from the room table and enter the picked value into the expense table.