Results 1 to 2 of 2
  1. #1
    eabreunig is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2016
    Posts
    8

    Autofill Form Based on Entry in 1 Field OR Manually Enter if that field is left blank

    I am pretty new to Access, so please forgive me if I don't provide all the information I should, but I've been tasked with updating a clunky database for my company to work more as we would like for keeping track of room fixtures on construction projects.

    A little background:

    We do construction on projects where there are many rooms that need identical fixtures installed (think hospital rooms). There are also some rooms that are unique. So, we may have 3 types of hospital rooms that account for 200 rooms in a building, and then a few oddball rooms. The database is currently set up so we have to manually assign fixtures to each room one at a time.

    What I would like to do is create a new table/form that allows me to build room types. Then, when I go to assigning fixtures to rooms, I would like to EITHER assign a room type (which would consequently assign all the fixtures to it) OR be able to manually assign the fixtures if it is one of those oddball rooms.

    I've played around with this idea for about a week but with such little knowledge of how the behind the scenes stuff in access works, I'm having trouble getting the database to behave this way.



    Any ideas would be much appreciated!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you'll have tables:
    tRooms, tRoomTypes, tFixtures, tRoomFixures

    all items in the tRoomTypes are filled in from tFixtures table
    Build your group in tRoomTypes

    tRoomTypes will have the 'TypeName' and all fixtures for it.
    RoomType, Fixture
    --------- -----------
    Bathroom, Pvc pipe1
    Bathroom, S pipe
    Bathroom, Bolt101

    tRoomFixures table hold all the child items in the Room

    make a form, select the room (from tRooms)
    select the RoomType: Bathroom
    a button will run an append query to add all items in tRoomType to the tRoomFixures

    tRoomFixures:
    RoomID, Fixture, RoomType
    A101, Pvc Pipe1, Bathroom
    A101, S Pipe, Bathroom

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 07-07-2016, 02:09 PM
  2. How to query if date field is left blank?
    By McArthurGDM in forum Queries
    Replies: 9
    Last Post: 08-04-2014, 05:18 PM
  3. Replies: 2
    Last Post: 09-13-2012, 03:42 PM
  4. Replies: 2
    Last Post: 07-14-2011, 09:23 AM
  5. Autofill form fields based on another field
    By ljs1277 in forum Access
    Replies: 3
    Last Post: 02-16-2010, 02:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums