Results 1 to 3 of 3
  1. #1
    Faeyren is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    4

    SubDatasheet Assistance Needed

    I am trying to set my RentalUnit Table to show each Tenant from Tenant in the subdatasheet. However it's blank.



    I am hoping someone can assist me in learning why it isn't showing up properly.

    http://imgur.com/a/fbw5f

    Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    tRentalUnit table should have a RenterID field. (aka PersonID)
    join the 2 tables on RenterID

  3. #3
    Faeyren is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    4
    [Edit] Nevermind! I have it working now (for now. Until I break it again lol.) Thank you so much!

    Turns out I was just over-complicating my nonsense with extra fields I didn't need.

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

Similar Threads

  1. 2x SubDataSheet in web database
    By Cazca in forum Access
    Replies: 1
    Last Post: 12-06-2015, 10:52 AM
  2. Replies: 7
    Last Post: 06-04-2015, 09:46 AM
  3. Exporting subdatasheet
    By DHIGHTO in forum Import/Export Data
    Replies: 3
    Last Post: 01-28-2015, 12:53 PM
  4. simple assistance needed
    By gkaro in forum Access
    Replies: 4
    Last Post: 10-17-2013, 11:41 AM
  5. Query Assistance Needed
    By elotromanuel in forum Queries
    Replies: 1
    Last Post: 03-17-2009, 09:31 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