Relationships

5,960 topics in this forum

1. Self Join using a calculated field

   By DFehrenbach, November 11, 2013
   • 4 replies
   • 1.1k views
   • 
   • DFehrenbach
   • November 11, 2013

2. 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
   • 944 views
   • 
   • comment
   • November 11, 2013

3. Relationship - tables and layouts

   By letitmatter, November 9, 2013
   • 1 reply
   • 1.6k views
   • 
   • Matthew F
   • November 10, 2013

4. Using a calculated field in a relationship

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

5. Using multiple criteria relationships to create filtered layout

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

6. Invoice Items Table Tracking Both Charges & Payments

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

7. A relational question from a quite simple implementation.

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

8. Timebased relationship for production. Is it possible ?

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

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

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

10. Extra fields for unknown reason

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

11. Humm Variable relationship , Im stumped

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

12. Container with data from other table

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

13. Basic Word Matching for Search Term Translations

    By FMRadio, September 29, 2013
    • 9 replies
    • 1.7k views
    • 
    • FMRadio
    • October 19, 2013

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

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

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

16. Many to many plus another?

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

17. Relationship or Value List...FM101 question

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

18. updating/ not updating

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

19. New to Relationship Question

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

20. Figures, Products and...superproducts?

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

21. Challenging Relationship

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

22. Related List

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

23. Create record in related table

    By FysiOlsen, September 25, 2013
    • 2 replies
    • 1.4k views
    • 
    • FysiOlsen
    • October 4, 2013

24. 1 or 2 tables?

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

25. recipes, sub-recipes...

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

26. Complex Relationship Question

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

27. How to show records automatically in a portal.

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

28. Relational Database for use with Instant Web Publishing

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

29. Ceating a value list from related tables

    By Filip Langenbick, September 16, 2013
    • 5 replies
    • 2.1k views
    • 
    • eos
    • September 21, 2013

30. One Relation Too Far

    By falkaholic, September 16, 2013
    • 5 replies
    • 1.6k views
    • 
    • falkaholic
    • September 20, 2013

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

    By eoneon123, September 19, 2013
    • 4 replies
    • 1.8k views
    • 
    • bcooney
    • September 20, 2013

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

    By GisMo, September 8, 2013
    • 3 replies
    • 3.7k views
    • 
    • Fenton
    • September 15, 2013

33. Need Help with Relationships

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

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

35. Some advice needed please

    By tomvassie, September 2, 2013
    • 6 replies
    • 1.2k views
    • 
    • alvathomson
    • September 7, 2013