Relationships

5,959 topics in this forum

1. New to FM - trying to understand relationships - and layouts - creating new record in one table from layout of related table

   By dawg, November 10, 2013
   • 9 replies
   • 939 views
   • 
   • comment
   • November 11, 2013

2. Relationship - tables and layouts

   By letitmatter, November 9, 2013   

   • relationship
   • tables
   • (and 1 more)

      Tagged with:

     • relationship
     • tables
     • scripts
   • 1 reply
   • 1.6k views
   • 
   • Matthew F
   • November 10, 2013

3. Using a calculated field in a relationship

   By nick_jp, November 9, 2013
   • 2 replies
   • 810 views
   • 
   • nick_jp
   • November 9, 2013

4. Using multiple criteria relationships to create filtered layout

   By jeremychance, November 6, 2013
   • 6 replies
   • 1.1k views
   • 
   • jeremychance
   • November 8, 2013

5. Invoice Items Table Tracking Both Charges & Payments

   By Dr. Evil, October 31, 2013
   • 2 replies
   • 1.3k views
   • 
   • Josh Ormond
   • November 7, 2013

6. A relational question from a quite simple implementation.

   By fmow, October 21, 2013
   • 5 replies
   • 1.6k views
   • 
   • Lee Smith
   • October 30, 2013

7. Timebased relationship for production. Is it possible ?

   By LooserX, October 28, 2013
   • 7 replies
   • 921 views
   • 
   • comment
   • October 30, 2013

8. Please explain how I do a "lookup" in FM12

   By philipcaplan, October 27, 2013
   • 11 replies
   • 1.4k views
   • 
   • comment
   • October 29, 2013

9. Extra fields for unknown reason

   By Charity, October 18, 2013
   • 12 replies
   • 1.2k views
   • 
   • comment
   • October 24, 2013

10. Humm Variable relationship , Im stumped

    By WSaxton, October 18, 2013
    • 3 replies
    • 1.1k views
    • 
    • Fitch
    • October 22, 2013

11. Container with data from other table

    By Coriolan_66, October 21, 2013
    • 1 reply
    • 754 views
    • 
    • comment
    • October 21, 2013

12. Basic Word Matching for Search Term Translations

    By FMRadio, September 29, 2013   

    • relationship
    • 9 replies
    • 1.7k views
    • 
    • FMRadio
    • October 19, 2013

13. Storing field data from multiple records (in a global text field)

    By sbphoto01, October 15, 2013
    • 4 replies
    • 1.1k views
    • 
    • sbphoto01
    • October 17, 2013

14. Multiple Table instances... it seems messy!

    By sbphoto01, October 15, 2013
    • 6 replies
    • 994 views
    • 
    • LaRetta
    • October 16, 2013

15. Many to many plus another?

    By David Nelson, October 10, 2013
    • 16 replies
    • 1.4k views
    • 
    • LaRetta
    • October 15, 2013

16. Relationship or Value List...FM101 question

    By jlarmen, October 14, 2013
    • 8 replies
    • 1k views
    • 
    • comment
    • October 15, 2013

17. updating/ not updating

    By peaceandplenty, September 28, 2013
    • 11 replies
    • 1.4k views
    • 
    • Matthew F
    • October 11, 2013

18. New to Relationship Question

    By drjmoo1, October 8, 2013
    • 6 replies
    • 931 views
    • 
    • comment
    • October 9, 2013

19. Figures, Products and...superproducts?

    By cresal, October 8, 2013
    • 1 reply
    • 756 views
    • 
    • mrubenson
    • October 8, 2013

20. Challenging Relationship

    By "... you mean these fans?", October 8, 2013
    • 4 replies
    • 988 views
    • 
    • "... you mean these fans?"
    • October 8, 2013

21. Related List

    By Mustafa55, October 4, 2013
    • 3 replies
    • 1.3k views
    • 
    • Lee Smith
    • October 4, 2013

22. Create record in related table

    By FysiOlsen, September 25, 2013   

    • script
    • 2 replies
    • 1.4k views
    • 
    • FysiOlsen
    • October 4, 2013

23. 1 or 2 tables?

    By tobbesfilemaker, September 26, 2013
    • 12 replies
    • 1.6k views
    • 
    • Wim Decorte
    • September 30, 2013

24. recipes, sub-recipes...

    By jeanyves, September 26, 2013
    • 2 replies
    • 1.8k views
    • 
    • RodSierra
    • September 26, 2013

25. Complex Relationship Question

    By niko, September 3, 2013
    • 11 replies
    • 1.8k views
    • 
    • niko
    • September 26, 2013

26. How to show records automatically in a portal.

    By nareyramos, August 23, 2013
    • 4 replies
    • 1k views
    • 
    • Lee Smith
    • September 25, 2013

27. Relational Database for use with Instant Web Publishing

    By mhemans, September 22, 2013
    • 1 reply
    • 848 views
    • 
    • Fitch
    • September 23, 2013

28. Ceating a value list from related tables

    By Filip Langenbick, September 16, 2013   

    • value list related tables
    • 5 replies
    • 2.1k views
    • 
    • eos
    • September 21, 2013

29. One Relation Too Far

    By falkaholic, September 16, 2013   

    • relationship
    • deep
    • (and 1 more)

       Tagged with:

      • relationship
      • deep
      • tricky
    • 5 replies
    • 1.6k views
    • 
    • falkaholic
    • September 20, 2013

30. possible to show multiple instances of same record in portal?

    By eoneon123, September 19, 2013   

    • portals
    • 4 replies
    • 1.8k views
    • 
    • bcooney
    • September 20, 2013

31. Filtering Records/Data From Multiple Tables - Multi-criteria For Charting Etc.

    By GisMo, September 8, 2013   

    • relationships
    • erd
    • (and 6 more)

       Tagged with:

      • relationships
      • erd
      • charts
      • charting
      • kpi
      • calculations
      • calculation engine
      • multi-criteria
    • 3 replies
    • 3.7k views
    • 
    • Fenton
    • September 15, 2013

32. Need Help with Relationships

    By tlhooper, September 11, 2013
    • 1 reply
    • 669 views
    • 
    • doughemi
    • September 12, 2013

33. Very early planning for equipment rental solution - is this relationship graph on the right track?

    By travelindude, August 29, 2013
    • 2 replies
    • 1.1k views
    • 
    • travelindude
    • September 9, 2013

34. Some advice needed please

    By tomvassie, September 2, 2013   

    • fm12
    • 6 replies
    • 1.2k views
    • 
    • alvathomson
    • September 7, 2013

35. Need a little direction with a Checklist

    By Rich S, September 6, 2013
    • 2 replies
    • 764 views
    • 
    • Rich S
    • September 6, 2013