Relationships

5,954 topics in this forum

1. Is this "Magic Key"?

   By human, November 9   

   • magic key
   • 3 replies
   • 125 views
   • 
   • human
   • November 10

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

   By dmontano, September 25
   • 2 replies
   • 291 views
   • 
   • dmontano
   • September 27

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

   By dmontano, August 14
   • 6 replies
   • 335 views
   • 
   • comment
   • August 15

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

   By jcclow, August 7
   • 3 replies
   • 147 views
   • 
   • comment
   • August 14

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

   By dmontano, July 8
   • 16 replies
   • 331 views
   • 
   • comment
   • July 10

6. Divide Record Categories into Separate Tables

   By Tmunix, May 27
   • 3 replies
   • 447 views
   • 
   • Søren Dyhr
   • June 1

7. Summarizing related records by field value

   By Tpaairman, May 10
   • 15 replies
   • 460 views
   • 
   • Søren Dyhr
   • May 17

8. Summarizing related records

   By Tpaairman, May 7
   • 7 replies
   • 242 views
   • 
   • Søren Dyhr
   • May 7

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

   By dmontano, April 29
   • 5 replies
   • 227 views
   • 
   • dmontano
   • April 30

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

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

11. Setting up relationships

    By Dave123, April 12
    • 7 replies
    • 373 views
    • 
    • Søren Dyhr
    • April 17

12. Relation with multiple fields

    By HGS, March 27
    • 2 replies
    • 342 views
    • 
    • HGS
    • March 27

13. Invoice with customer and contact

    By Simplified, March 12
    • 4 replies
    • 314 views
    • 
    • Simplified
    • March 12

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

    By Nikos, January 7
    • 5 replies
    • 805 views
    • 
    • comment
    • January 10

15. Data modeling and Relational Graph

    By centauri272, November 27, 2023   

    • schema
    • structure
    • (and 1 more)

       Tagged with:

      • schema
      • structure
      • relationships
    • 0 replies
    • 522 views
    • 
    • centauri272
    • November 27, 2023

16. Schema for payments vs expenses

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

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

    By JudyMom, November 3, 2023
    • 4 replies
    • 592 views
    • 
    • JudyMom
    • November 4, 2023

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

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

19. Company > Contacts: multiple relationships

    By JenniSTM, October 27, 2023
    • 2 replies
    • 356 views
    • 
    • JenniSTM
    • October 27, 2023

20. Inventory database - sensible table structure

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

21. Best relationship to count "customers per month"

    By Angus McKinnon, August 23, 2023
    • 4 replies
    • 419 views
    • 
    • Angus McKinnon
    • August 23, 2023

22. Display Grandchildren in a Portal

    By stxlen, July 20, 2023   

    • filemaker
    • portal
    • (and 1 more)

       Tagged with:

      • filemaker
      • portal
      • child tables
    • 5 replies
    • 847 views
    • 
    • stxlen
    • July 20, 2023

23. Relationship to another hosted database and authentication

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

24. Creating A Relational DB from a Flat File

    By CBarnes, June 5, 2023
    • 5 replies
    • 595 views
    • 
    • comment
    • June 6, 2023

25. Trying to get portal to filter duplicates & summarize

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

26. Converting spider web to anchor bouy

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

27. Curious how to create a loop

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

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

    By databaser, November 16, 2022
    • 1 reply
    • 530 views
    • 
    • comment
    • November 16, 2022

29. join table question - multiple users?

    By human, November 7, 2022
    • 13 replies
    • 826 views
    • 
    • comment
    • November 13, 2022

30. Is a portal empty

    By Raymack, November 1, 2022
    • 3 replies
    • 874 views
    • 
    • Raymack
    • November 1, 2022

31. Populating a Relational Database from available data files

    By Raymack, October 20, 2022
    • 8 replies
    • 742 views
    • 
    • Raymack
    • October 23, 2022

32. Reporting Subsummary results from a CheckBox Set

    By Raymack, October 12, 2022
    • 8 replies
    • 830 views
    • 
    • Raymack
    • October 13, 2022

33. transfer a found set to a different already-existent window

    By Glenn S., June 24, 2018
    • 11 replies
    • 1.4k views
    • 
    • GFS
    • September 20, 2022

34. Count of related records, sort of

    By RSGC, August 27, 2022
    • 5 replies
    • 412 views
    • 
    • comment
    • August 28, 2022

35. Unmodifiable field

    By carlosnorvik, August 4, 2022
    • 2 replies
    • 512 views
    • 
    • comment
    • August 17, 2022