Relationships

5,960 topics in this forum

1. Movie Database Multiple Actors, Directors Joining table

   By TaiChi56, February 14, 2021
   • 6 replies
   • 16.4k views
   • 
   • comment
   • September 7

2. Nested portal issue

   By NeyRam, July 12
   • 9 replies
   • 2.5k views
   • 
   • comment
   • July 30

3. Schema for relationships based on information from the parent table

   By Angus McKinnon, January 17
   • 11 replies
   • 1.7k views
   • 
   • Angus McKinnon
   • July 28

4. Thoughts on separate tables for IMAGES and DOCUMENTS?

   By dmontano, June 23
   • 2 replies
   • 964 views
   • 
   • dmontano
   • June 24

5. Portal entry?

   By Clayton King, March 22
   • 3 replies
   • 1.4k views
   • 
   • comment
   • March 23

6. M-to-M Records Appearing More than Once in Field

   By tatihulot, February 25
   • 11 replies
   • 1.3k views
   • 
   • tatihulot
   • February 26

7. How to set up schema for a report involving two children tables

   By 21st Century Man, December 5, 2024
   • 3 replies
   • 504 views
   • 
   • comment
   • December 5, 2024

8. Is this "Magic Key"?

   By human, November 9, 2024
   • 3 replies
   • 1.2k views
   • 
   • human
   • November 10, 2024

9. Need help building a many "Code" functionality.

   By dmontano, September 25, 2024
   • 2 replies
   • 676 views
   • 
   • dmontano
   • September 27, 2024

10. Thoughts, Advice on my Table and Relationship Schema for Images

    By dmontano, August 14, 2024
    • 6 replies
    • 1.5k views
    • 
    • comment
    • August 15, 2024

11. Table design question for tracking projects with and without sub-projects

    By jcclow, August 7, 2024
    • 3 replies
    • 458 views
    • 
    • comment
    • August 14, 2024

12. How to display ONLY the current status in a one-to-many relationship on the "parent" table?

    By dmontano, July 8, 2024
    • 16 replies
    • 1.2k views
    • 
    • comment
    • July 10, 2024

13. Divide Record Categories into Separate Tables

    By Tmunix, May 27, 2024
    • 3 replies
    • 1.6k views
    • 
    • Søren Dyhr
    • June 1, 2024

14. Summarizing related records by field value

    By Tpaairman, May 10, 2024
    • 15 replies
    • 1.7k views
    • 
    • Søren Dyhr
    • May 17, 2024

15. Summarizing related records

    By Tpaairman, May 7, 2024
    • 7 replies
    • 1.4k views
    • 
    • Søren Dyhr
    • May 7, 2024

16. Request for Estimate and Items (as either Components or Composites)

    By dmontano, April 29, 2024
    • 5 replies
    • 1.2k views
    • 
    • dmontano
    • April 30, 2024

17. Relationship to filter records based on grandchild Table::Field

    By RSGC, April 13, 2024
    • 14 replies
    • 982 views
    • 
    • Søren Dyhr
    • April 21, 2024

18. Setting up relationships

    By Dave123, April 12, 2024
    • 7 replies
    • 1.7k views
    • 
    • Søren Dyhr
    • April 17, 2024

19. Relation with multiple fields

    By HGS, March 27, 2024
    • 2 replies
    • 1.4k views
    • 
    • HGS
    • March 27, 2024

20. Invoice with customer and contact

    By Simplified, March 12, 2024
    • 4 replies
    • 563 views
    • 
    • Simplified
    • March 12, 2024

21. Comparing hours from one table to time slots in another table

    By Nikos, January 7, 2024
    • 5 replies
    • 1.9k views
    • 
    • comment
    • January 10, 2024

22. Data modeling and Relational Graph

    By centauri272, November 27, 2023
    • 0 replies
    • 1.5k views
    • 
    • centauri272
    • November 27, 2023

23. Schema for payments vs expenses

    By blissland, November 26, 2023
    • 8 replies
    • 650 views
    • 
    • bcooney
    • November 27, 2023

24. Why won't same info load in multiple places? Why portal won't work ever?

    By JudyMom, November 3, 2023
    • 4 replies
    • 1.7k views
    • 
    • JudyMom
    • November 4, 2023

25. Wanted to use DisplayID on layout but need UUID in the relationship

    By Spidey, November 1, 2023
    • 11 replies
    • 1.6k views
    • 
    • Ocean West
    • November 3, 2023

26. Company > Contacts: multiple relationships

    By JenniSTM, October 27, 2023
    • 2 replies
    • 1.3k views
    • 
    • JenniSTM
    • October 27, 2023

27. Inventory database - sensible table structure

    By Angus McKinnon, October 25, 2020
    • 4 replies
    • 2k views
    • 
    • comment
    • August 26, 2023

28. Best relationship to count "customers per month"

    By Angus McKinnon, August 23, 2023
    • 4 replies
    • 1.7k views
    • 
    • Angus McKinnon
    • August 23, 2023

29. Display Grandchildren in a Portal

    By stxlen, July 20, 2023
    • 5 replies
    • 1.9k views
    • 
    • stxlen
    • July 20, 2023

30. Relationship to another hosted database and authentication

    By Chrism, June 27, 2023
    • 3 replies
    • 581 views
    • 
    • rwoods
    • July 19, 2023

31. Creating A Relational DB from a Flat File

    By CBarnes, June 5, 2023
    • 5 replies
    • 1.7k views
    • 
    • comment
    • June 6, 2023

32. Trying to get portal to filter duplicates & summarize

    By RRS, April 13, 2023
    • 3 replies
    • 885 views
    • 
    • RRS
    • April 13, 2023

33. Converting spider web to anchor bouy

    By cwcrogan, January 4, 2023
    • 3 replies
    • 2.2k views
    • 
    • comment
    • January 4, 2023

34. Curious how to create a loop

    By Lisa M., November 27, 2022
    • 2 replies
    • 1.7k views
    • 
    • Lisa M.
    • November 27, 2022

35. Calculate the earliest date (field B) a number (field A) was exceeded

    By databaser, November 16, 2022
    • 1 reply
    • 1.4k views
    • 
    • comment
    • November 16, 2022