Relationships

5,896 topics in this forum

1. Relationship graph - can't work it out.

   By Greg58, Tuesday at 06:12 AM
   • 5 replies
   • 108 views
   • 
   • comment
   • Wednesday at 12:56 AM

2. Why can't I sort a table by a related field?

   By naio, April 24
   • 3 replies
   • 60 views
   • 
   • naio
   • May 7

3. Constants in relationships

   By passando, May 1
   • 2 replies
   • 46 views
   • 
   • comment
   • May 1

4. Go To Related Record, going to the wrong Table! (ie wrong direction)

   By Slater, March 22
   • 2 replies
   • 56 views
   • 
   • Slater
   • March 22

5. Self join set-up question

   By Hurlz, March 16
   • 2 replies
   • 70 views
   • 
   • Hurlz
   • March 17

6. Show record only if ...

   By Martin_01, March 11
   • 1 reply
   • 73 views
   • 
   • comment
   • March 11

7. Multi relationship

   By Chrism, March 2
   • 0 replies
   • 45 views
   • 
   • Chrism
   • March 2

8. Importing records from a text file and matching (maybe) misspelled names?

   By AJ Venice, February 26
   • 0 replies
   • 39 views
   • 
   • AJ Venice
   • February 26

9. Need conditional dropdown of values - just need help making sure my relationship is correct.

   By wfcperrine12, February 17
   • 2 replies
   • 49 views
   • 
   • wfcperrine12
   • February 18

10. Displaying portal info table occurances rather than original table

    By Hurlz, February 15
    • 3 replies
    • 82 views
    • 
    • Hurlz
    • February 17

11. I can't figure out how to retrieve a value based on two established values.

    By wfcperrine12, February 16
    • 2 replies
    • 66 views
    • 
    • wfcperrine12
    • February 16

12. Movie Database Multiple Actors, Directors Joining table

    By TaiChi56, February 14
    • 4 replies
    • 88 views
    • 
    • TaiChi56
    • February 14

13. Auto-fill a field based on a second table

    By Noam, January 28
    • 6 replies
    • 106 views
    • 
    • Noam
    • January 28

14. Stuck - need help schedule/enrollment update relationship?

    By AJ Venice, January 27
    • 0 replies
    • 63 views
    • 
    • AJ Venice
    • January 27

15. General Database Structure Query

    By Mark12345, January 27
    • 2 replies
    • 91 views
    • 
    • Ocean West
    • January 27

16. Do I Need to Create a Relational Data-base to Auto-generate a Field based on my Primary Key?

    By modern_archaeologist, January 19
    • 6 replies
    • 150 views
    • 
    • comment
    • January 21

17. Many to Many self-join

    By Hurlz, December 16, 2020
    • 6 replies
    • 180 views
    • 
    • Greg58
    • January 10

18. Multi-dimensional query - SQL hard-code or related tables?

    By DataCruncher, January 2
    • 5 replies
    • 98 views
    • 
    • comment
    • January 2

19. Creating an OR relationship

    By Chrism, December 10, 2020
    • 2 replies
    • 84 views
    • 
    • Chrism
    • December 10, 2020

20. How to use "allow creation of records"...and "delete related records in this table"...in the left side in the edit relationship

    By Spidey, December 4, 2020
    • 2 replies
    • 97 views
    • 
    • Spidey
    • December 6, 2020

21. Need Help with Relationship

    By Jennifer, November 12, 2020
    • 2 replies
    • 108 views
    • 
    • Jennifer
    • November 12, 2020

22. Inventory database - sensible table structure

    By Angus McKinnon, October 25, 2020
    • 2 replies
    • 132 views
    • 
    • bcooney
    • November 5, 2020

23. Conditional Value List

    By Tracy, October 31, 2020
    • 4 replies
    • 134 views
    • 
    • Tracy
    • November 2, 2020

24. How to get data from one table to use in another when the tables don't really need to be related.

    By JMW, July 21, 2020   

    • relationship problem
    • 6 replies
    • 328 views
    • 
    • JMW
    • September 16, 2020

25. Relationships and portals

    By Chrism, September 11, 2020
    • 3 replies
    • 103 views
    • 
    • Chrism
    • September 11, 2020

26. Portal displaying conditional values based on selection and current user

    By McScripta, September 1, 2020
    • 3 replies
    • 158 views
    • 
    • McScripta
    • September 2, 2020

27. Append in field vs. Details table

    By Idahomail, September 1, 2020
    • 0 replies
    • 116 views
    • 
    • Idahomail
    • September 1, 2020

28. Relationship across 2 TOC's

    By Greg58, August 28, 2020
    • 4 replies
    • 98 views
    • 
    • Greg58
    • August 31, 2020

29. Managing cross references - permuting and commuting

    By DZ3, August 8, 2020
    • 2 replies
    • 92 views
    • 
    • DZ3
    • August 9, 2020

30. Custom order appears to have been lost

    By jjjjp, August 6, 2020
    • 6 replies
    • 144 views
    • 
    • jjjjp
    • August 7, 2020

31. Scheme for an editorial flow - Recommendations

    By Mauriki, August 7, 2020
    • 1 reply
    • 121 views
    • 
    • comment
    • August 7, 2020

32. What is a good schema to represent keystones in 3 space?

    By Danxyz, July 14, 2020
    • 6 replies
    • 237 views
    • 
    • comment
    • July 14, 2020

33. Table Relationships and Value Lists?

    By Tony Diaz, June 26, 2020
    • 6 replies
    • 868 views
    • 
    • Wim Decorte
    • June 28, 2020

34. How to structure, would this be Many-to-Many?

    By Tony Diaz, June 20, 2020   

    • relationships
    • many-to-many
    • (and 2 more)

       Tagged with:

      • relationships
      • many-to-many
      • value list
      • portal
    • 3 replies
    • 982 views
    • 
    • comment
    • June 20, 2020

35. In a relationship table, is it ok to use two foreign key of a combination ID to connect to each other?

    By Spidey, June 16, 2020
    • 0 replies
    • 982 views
    • 
    • Spidey
    • June 16, 2020