Relationships

5,957 topics in this forum

1. How do I create a value list which contains records from two tables

   By plchri, March 21, 2016
   • 4 replies
   • 890 views
   • 
   • plchri
   • March 21, 2016

2. Table Relationships advice needed

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

3. Copy records from FM to MySQL

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

4. Help with Container

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

5. Self join Relationship or New Table?

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

6. How to show related fields in another table.

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

7. Psychotherapy DB

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

8. Portal to show all records for selected record

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

9. Guidelines for when to make a new table?

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

10. Relationship with spaces in field values

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

11. Multi-Predicate or Alternative Key

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

12. Many to Many ralationship

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

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

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

14. 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

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

    By Hoytopher, February 9, 2016   

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

16. 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

17. Use of Portal on Unrelated Table on Main Menu

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

18. 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

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

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

20. Can't get MaxDate from external FM file

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

21. Please Please Help!!!

    By cheerfulzebra, February 10, 2016   

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

22. Calling two separate related records

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

23. 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
    • 880 views
    • 
    • Dimitrios Fkiaras
    • February 9, 2016

24. Related data all in one field

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

25. Files & Tables Consolidation

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

26. 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

27. Proper structure to archive data

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

28. Filtering by Related Record

    By mmarino, February 2, 2016   

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

29. 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

30. Lookup field when related records change

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

31. 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.6k views
    • 
    • Jo_In_Oz
    • January 29, 2016

32. Invalid Table relationship

    By Spidey, January 27, 2016
    • 3 replies
    • 1k views
    • 
    • webko
    • January 27, 2016

33. FM Relationship Error Message

    By Spidey, January 26, 2016   

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

34. Static Worksheet to Active Project and Related Data

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

35. 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