Relationships

5,956 topics in this forum

1. Table Relationships advice needed

   By UltraNIX, March 16, 2016
   • 5 replies
   • 954 views
   • 
   • Wim Decorte
   • March 20, 2016

2. Copy records from FM to MySQL

   By Marcwa19197, February 24, 2016
   • 8 replies
   • 1.3k views
   • 
   • ggt667
   • March 14, 2016

3. Help with Container

   By muskee, March 10, 2016
   • 1 reply
   • 795 views
   • 
   • bcooney
   • March 10, 2016

4. Self join Relationship or New Table?

   By Dimitrios Fkiaras, March 9, 2016
   • 5 replies
   • 943 views
   • 
   • Lee Smith
   • March 9, 2016

5. How to show related fields in another table.

   By nareyramos, March 9, 2016
   • 2 replies
   • 826 views
   • 
   • LaRetta
   • March 9, 2016

6. Psychotherapy DB

   By Auraboros, February 4, 2016
   • 27 replies
   • 1.9k views
   • 
   • Auraboros
   • March 2, 2016

7. Portal to show all records for selected record

   By Chris Thacker, February 29, 2016
   • 12 replies
   • 970 views
   • 
   • Chris Thacker
   • March 1, 2016

8. Guidelines for when to make a new table?

   By nycpost, February 28, 2016
   • 4 replies
   • 967 views
   • 
   • Fitch
   • February 29, 2016

9. Relationship with spaces in field values

   By pjulian, February 29, 2016
   • 1 reply
   • 645 views
   • 
   • comment
   • February 29, 2016

10. Multi-Predicate or Alternative Key

    By Ocean West, February 26, 2016
    • 0 replies
    • 871 views
    • 
    • Ocean West
    • February 26, 2016

11. Many to Many ralationship

    By H, February 25, 2016
    • 1 reply
    • 825 views
    • 
    • comment
    • February 25, 2016

12. Parent and child records in same portal with relationship doesnt exist

    By Gerry, February 22, 2016
    • 2 replies
    • 886 views
    • 
    • Gerry
    • February 23, 2016

13. Taxonomy database setup advise

    By Alex8, February 9, 2016   

    • taxonomy
    • database
    • (and 2 more)

       Tagged with:

      • taxonomy
      • database
      • hierarchy
      • setup
    • 7 replies
    • 2k views
    • 
    • Alex8
    • February 18, 2016

14. Trying to organize a company->company->employee database

    By Hoytopher, February 9, 2016   

    • sorting
    • organization
    • 5 replies
    • 2.3k views
    • 
    • comment
    • February 17, 2016

15. Self-Join Relationship for finding Duplicate Value with "OR" condition

    By dav1089, February 12, 2016   

    • self-join
    • relationship
    • (and 1 more)

       Tagged with:

      • self-join
      • relationship
      • duplicate records with similar fields
    • 4 replies
    • 1.5k views
    • 
    • dav1089
    • February 16, 2016

16. Use of Portal on Unrelated Table on Main Menu

    By John Kostenbader, February 12, 2016
    • 3 replies
    • 1k views
    • 
    • comment
    • February 13, 2016

17. Creating New Contact from Company Table

    By BeginnerForever, December 10, 2015   

    • contact
    • company
    • (and 4 more)

       Tagged with:

      • contact
      • company
      • tables
      • relationships
      • fields
      • popover
    • 9 replies
    • 2.5k views
    • 
    • M_ichel
    • February 11, 2016

18. One to many - many to one with four tables

    By frankb3, February 10, 2016
    • 0 replies
    • 792 views
    • 
    • frankb3
    • February 10, 2016

19. Can't get MaxDate from external FM file

    By b.hunt, February 10, 2016
    • 1 reply
    • 577 views
    • 
    • webko
    • February 10, 2016

20. Please Please Help!!!

    By cheerfulzebra, February 10, 2016   

    • hire database
    • 5 replies
    • 963 views
    • 
    • Fitch
    • February 10, 2016

21. Calling two separate related records

    By mmarino, February 10, 2016
    • 2 replies
    • 712 views
    • 
    • Kris M
    • February 10, 2016

22. One-to-Many Relationship with OR operator?

    By Dimitrios Fkiaras, February 8, 2016   

    • one-many
    • or-operator
    • (and 1 more)

       Tagged with:

      • one-many
      • or-operator
      • multipe-match-fields
    • 2 replies
    • 863 views
    • 
    • Dimitrios Fkiaras
    • February 9, 2016

23. Related data all in one field

    By Tpaairman, February 6, 2016
    • 6 replies
    • 1.3k views
    • 
    • comment
    • February 9, 2016

24. Files & Tables Consolidation

    By SarahS, February 1, 2016
    • 4 replies
    • 1.4k views
    • 
    • SarahS
    • February 3, 2016

25. Need Help Creating Enrollment Form

    By Briana, February 2, 2016   

    • enrollmentform
    • checklist
    • (and 1 more)

       Tagged with:

      • enrollmentform
      • checklist
      • pc
    • 5 replies
    • 1.5k views
    • 
    • comment
    • February 3, 2016

26. Proper structure to archive data

    By Greg Tuite, February 3, 2016
    • 0 replies
    • 640 views
    • 
    • Greg Tuite
    • February 3, 2016

27. Filtering by Related Record

    By mmarino, February 2, 2016   

    • related record
    • filter
    • 0 replies
    • 3.7k views
    • 
    • mmarino
    • February 2, 2016

28. Relating tables with month and year

    By Agentshevy, January 29, 2016   

    • relationship
    • month
    • (and 1 more)

       Tagged with:

      • relationship
      • month
      • year
    • 15 replies
    • 1.5k views
    • 
    • Agentshevy
    • February 2, 2016

29. Lookup field when related records change

    By Matt Malyschko, January 30, 2016
    • 2 replies
    • 941 views
    • 
    • Matt Malyschko
    • January 31, 2016

30. How to manage hundreds of fields and their related records

    By Jo_In_Oz, January 25, 2016   

    • fields
    • tables
    • (and 1 more)

       Tagged with:

      • fields
      • tables
      • relationships
    • 31 replies
    • 3.5k views
    • 
    • Jo_In_Oz
    • January 29, 2016

31. Invalid Table relationship

    By Spidey, January 27, 2016
    • 3 replies
    • 994 views
    • 
    • webko
    • January 27, 2016

32. FM Relationship Error Message

    By Spidey, January 26, 2016   

    • relationship
    • 2 replies
    • 1.7k views
    • 
    • Spidey
    • January 26, 2016

33. Static Worksheet to Active Project and Related Data

    By SimmKa, January 23, 2016
    • 5 replies
    • 921 views
    • 
    • comment
    • January 26, 2016

34. Join table to link clientID to IndicatorID

    By Jo_In_Oz, January 25, 2016   

    • relationships
    • 7 replies
    • 1.2k views
    • 
    • Jo_In_Oz
    • January 25, 2016

35. Creating a button that copies data from one table record to another.

    By MutantST, January 18, 2016   

    • buttons
    • tables
    • (and 1 more)

       Tagged with:

      • buttons
      • tables
      • copying info
    • 16 replies
    • 1.7k views
    • 
    • MutantST
    • January 24, 2016