Relationships

5,956 topics in this forum

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

   By wfcperrine12, February 17, 2021
   • 2 replies
   • 486 views
   • 
   • wfcperrine12
   • February 18, 2021

2. Displaying portal info table occurances rather than original table

   By Hurlz, February 15, 2021
   • 3 replies
   • 594 views
   • 
   • Hurlz
   • February 17, 2021

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

   By wfcperrine12, February 16, 2021
   • 2 replies
   • 524 views
   • 
   • wfcperrine12
   • February 16, 2021

4. Movie Database Multiple Actors, Directors Joining table

   By TaiChi56, February 14, 2021
   • 4 replies
   • 907 views
   • 
   • TaiChi56
   • February 14, 2021

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

   By Noam, January 28, 2021
   • 6 replies
   • 1k views
   • 
   • Noam
   • January 28, 2021

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

   By AJ Venice, January 27, 2021
   • 0 replies
   • 463 views
   • 
   • AJ Venice
   • January 27, 2021

7. General Database Structure Query

   By Mark12345, January 27, 2021
   • 2 replies
   • 844 views
   • 
   • Ocean West
   • January 27, 2021

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

   By modern_archaeologist, January 19, 2021
   • 6 replies
   • 1.2k views
   • 
   • comment
   • January 21, 2021

9. Many to Many self-join

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

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

    By DataCruncher, January 2, 2021
    • 5 replies
    • 610 views
    • 
    • comment
    • January 2, 2021

11. Creating an OR relationship

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

12. 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
    • 512 views
    • 
    • Spidey
    • December 6, 2020

13. Need Help with Relationship

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

14. Conditional Value List

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

15. 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
    • 1.1k views
    • 
    • JMW
    • September 16, 2020

16. Relationships and portals

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

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

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

18. Append in field vs. Details table

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

19. Relationship across 2 TOC's

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

20. Managing cross references - permuting and commuting

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

21. Custom order appears to have been lost

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

22. Scheme for an editorial flow - Recommendations

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

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

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

24. Table Relationships and Value Lists?

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

25. 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
    • 1.8k views
    • 
    • comment
    • June 20, 2020

26. 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
    • 1.4k views
    • 
    • Spidey
    • June 16, 2020

27. Determine safety of deleting table occurrence

    By Pumpkin_Escobar, June 2, 2020
    • 3 replies
    • 1.6k views
    • 
    • Fitch
    • June 7, 2020

28. What is the 'Good Way' to Do a Relationship ... and Avoid Duplicate Entries?

    By Tony Diaz, June 3, 2020
    • 11 replies
    • 1.7k views
    • 
    • bcooney
    • June 6, 2020

29. Retrieve Data From Crosstab Table

    By Spidey, June 1, 2020
    • 1 reply
    • 1.6k views
    • 
    • Ocean West
    • June 1, 2020

30. many to many relationship between 2 occurrences of the same table via a join table

    By Philem63, June 1, 2020
    • 1 reply
    • 1.9k views
    • 
    • Ocean West
    • June 1, 2020

31. Changing the match field in a relationship (without breaking anything)

    By Angus McKinnon, May 8, 2020
    • 3 replies
    • 2.1k views
    • 
    • Angus McKinnon
    • May 22, 2020

32. Merging duplicates with child records

    By Matt.C, May 18, 2020
    • 0 replies
    • 2k views
    • 
    • Matt.C
    • May 18, 2020

33. Find Field via Relationship

    By sirsancho09, May 13, 2020
    • 6 replies
    • 2.1k views
    • 
    • sirsancho09
    • May 14, 2020

34. Get count of related records with specific field value

    By BrainlessBlock, May 7, 2020   

    • relationships
    • 1 reply
    • 3.2k views
    • 
    • comment
    • May 7, 2020

35. Display Related Field In Subsummary Part

    By Jay86, May 4, 2020   

    • related field
    • subsummary
    • (and 1 more)

       Tagged with:

      • related field
      • subsummary
      • lookup values
    • 3 replies
    • 2.2k views
    • 
    • Jay86
    • May 4, 2020