+ Reply to Thread
Results 1 to 3 of 3

Relationships Not Showing - 2016.

  1. #1
    Forum Contributor
    Join Date
    02-09-2009
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    273

    Relationships Not Showing - 2016.

    I cannot see a one-to-many relationship in the relationship view. The L,P,M,P table feeds the Parents table, which is showing in Object Dependancies, but not showing in the relationships view. Can anyone advise what's going on?

    I've seen a thread where somebody updated their display driver & this worked, amongst the obvious right-click > show all relationships, but I cannot seem to get it.

    EDIT - Tried Compact & Repair Database Tools but has not worked, & this should not be required anyways, as only a minuscule thing here. I renamed a table so that may be causing issues, but obviously renaming a table is an essential thing. If one cannot rename a table without catastrophic effect then I may want to upgrade to a typewriter. I'll be writing my own C# app soon, but I'm in a rush to get this cracking so I need to get the preliminary done in Access first.
    Last edited by Dal123; 07-12-2020 at 12:22 PM.
    If it's been helpful please mark as helpful

  2. #2
    Forum Contributor
    Join Date
    02-09-2009
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    273

    Re: Relationships Not Showing - 2016.

    Sorry, I think it may be to do with the fact it's a lookup field? But I am stumped as to why it would not be displayed in the relationship hierarchy?

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,932

    Re: Relationships Not Showing - 2016.

    Is your lookup in a Table or in a Form. If in a Table, you really should avoid this type of activity. Do your lookups in a Form and not in the table.

    http://access.mvps.org/access/lookupfields.htm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Showing organizational reporting relationships in a table
    By Brunswick in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-04-2020, 08:30 AM
  2. Replies: 7
    Last Post: 06-02-2019, 11:09 AM
  3. Replies: 0
    Last Post: 08-16-2018, 03:14 PM
  4. Please help! date showing as 1900/01/0 on excel 2016
    By toodles779 in forum Excel General
    Replies: 8
    Last Post: 07-22-2018, 06:23 AM
  5. [SOLVED] Power Pivot not showing in excel 2016 one time purchase version
    By sovietchild in forum Excel General
    Replies: 5
    Last Post: 01-22-2018, 09:40 AM
  6. Excel 2016 Cell remains blank not showing the result
    By Keebellah in forum Excel General
    Replies: 6
    Last Post: 12-12-2017, 07:26 AM
  7. Replies: 1
    Last Post: 09-18-2017, 08:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1