I want to create a type of pick list

[ehamike]

I have 2 tables. The 1st one is tblRooms. It contains a list of all the rooms available to projects. tblRooms contains just 2 fields:

• RoomId (key)
• RoomName

The second table is tblProjectRooms. It has 4 fields:

• ProjectRoomID (key)
• ProjectID
• RoomID
• RoomSortOrder

tblProjectRooms contains the room info for all projects. Each project uses a subset of the rooms from tblRooms. What I would like to do is create a form that has a combobox at the top where you select a project. A "table" on the form would show all the rooms (RoomName field) from tblRoom in one column. The 2nd column would show (ideally) a checkbox that is checked if the project contains that particular room. The 3rd column would contain the sort order for that room.

So a user could select a project from the combobox and see all the rooms available for the project. The could then check the boxes for the ones they wanted included, or uncheck to remove it.

I can't figure out how to get the check box capability and have all the rooms available in the form.

Is this hard, easy.. or should I be trying another approach (I have thought about having 2 listboxes and adding from the tblRoom listbox to the tblProjectRoom listbox, but liked this approach better)