Good morning - I've watched MANY hours of videos and searched forums but I haven't found my answer. Most likely because I'm not searching correctly. So, I've been worn down and need to ask for help. (I'm not good at asking for help). By the way, I know one SQL command - SELECT so I'm using the form designer and such.
Here's my scenario - I'm performing a space management inventory for a small college. I've created tables and populated them with known information (addresses, building names, organization types, codes, etc) (see Relationship image below). I'd like to create a data entry form that will be populated as we walk thru each building that will populate my Spaces table.
Form design (attached is a mockup of my idea)- Here's my idea but not real sure how to move forward. User would select building address from combo box. Once address was selected the subform? would display any previously entered spaces for that address (existing data). Between the address combo box and the Existing Data subform is a space to enter the necessary data for the new space. Also, I don't want the User to be able to make changes to existing data (that will occur with a change form request). If this post is incorrectly placed or not appropriate, please just let me know.
I appreciate any and all help you can provide. Thanks.