Results 1 to 5 of 5
  1. #1
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116

    Sub table?


    Hello.

    I've decided to get organized, and create a database of all the belongings in my home, for both me and my partner. I might as well do something useful during lockdown! I've got one question though.

    I plan to create a table that lists all the rooms in the house. Then I'd also like to list all the locations within those rooms (say top draw, box under bed etc). I might be over thinking this, but do I need to create the locations in the room as a sub table to the room itself (is that even possible?)? I'm just struggling to get my head around it at the moment.

    Many thanks for your help.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I recommend you create a narrative in simple terms about your proposed database and application. It is not as easy as many think to clearly describe WHAT your business is/will be. Consider the "things" involved(entities), the particular characteristics of each(attributes) that are important for your business and how these things relate to one another (relationships). After you have the narrative, you can use pencil and paper (or whiteboard or cardboard or ...) to develop and refine a data model. Create some test data and vet your model.
    Work through 1 or 2 tutorials from RogersAccessLibrary that can be found in the Database Planning and Design link in my signature.
    Good luck.

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    You will need at least the following tables:-

    tblHouseRooms
    -HouseRoomID - PK - Autonumber
    -RoomID - FK - Number (Linked to PK from tblRooms)

    tblRooms
    -RoomID - PK - Autonumber
    -Room - Text
    (This table contains a List of all the Rooms in the House)

    tblRoomLocations
    -RoomLocationID - PK - Autonumber
    -HouseRoomID - FK - Number (Linked to tblHouseRooms on PK)
    -Location
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  4. #4
    neilsolaris is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2020
    Posts
    116
    Many thanks Orange and Mike.

    That's exactly the advice I was looking for Mike, that's really helpful, thanks!

  5. #5
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    We were both glad to help.

    You would now create a Main Form / Subform layout for your Data Input
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 1
    Last Post: 07-07-2017, 01:10 AM
  2. Replies: 1
    Last Post: 03-31-2016, 03:33 AM
  3. Replies: 4
    Last Post: 08-30-2012, 07:58 PM
  4. Replies: 8
    Last Post: 03-22-2012, 08:48 AM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

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