Solved

FileMakerPro 10 relationships

Posted on 2014-12-03
11
213 Views
Last Modified: 2015-01-05
I have three tables A, B, and C. (agencies, buildings, cataloging)
I want data from a field in table A to appear in a layout based on table C.
Using the TO of C->B->A only shows the data in the new field if there is data in an other field related to the A table. (C->A)This field is empty more often than not and is not necessary for the report.
C is related to B by bldgID and B is related to A by agencyCode.
How do I get the data to display?
0
Comment
Question by:maryj152
  • 4
  • 4
  • 2
11 Comments
 
LVL 11

Expert Comment

by:Andrew Angell
ID: 40480496
Create a field in each table called something like StaticRelationship.  Make it a global number field, and give it a value of 1.

Then you can create a table occurrence called something like AgenciesToCataloggingByStaticRel, and use the StaticRelationship field as the relationship.  

Since each table will have the same value in that field, it will always relate, so you can always use that table occurrence to display data.
0
 
LVL 6

Expert Comment

by:slinkygn
ID: 40480515
You don't need to use the above anymore.  Since FileMaker 7, one has the ability to use a Cartesian join (looks like an X in the relationship graph) to see all data through a relationship.  (The relationship can be between any two fields in the tables you want to relate; since the Cartesian operator will show all data anyway, the specific field you choose won't matter.)
http://help.filemaker.com/app/answers/detail/a_id/5463/~/using-the-cartesian-product-relationship-in-filemaker-pro
Relate A to C in that way and you should be able to see all of A's data.

Now, if you mean that you want to show a *particular* bit of data in C from A, and it's not showing up through the relationship, that usually means your relationships aren't defined well -- in other words, the data isn't necessarily structured to match what you were intending it to do.  But to troubleshoot that, we'd need more information as to what data you're storing and how it is related in a real-world sense.
0
 
LVL 11

Expert Comment

by:Andrew Angell
ID: 40480576
Good to know.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:maryj152
ID: 40481064
There are no common fields between A and C.
Can I just choose any two fields and use the X relationship?
0
 
LVL 6

Accepted Solution

by:
slinkygn earned 500 total points
ID: 40481069
Yup! The Cartesian join doesn't care what fields it's on. It'll always present all data across the relationship.
0
 

Author Closing Comment

by:maryj152
ID: 40481224
Thank you. Now I need to solve something else.
0
 

Author Comment

by:maryj152
ID: 40489695
I do need " to show a *particular* bit of data in C's layout  from table A,".
As I mentioned the two tables are not related but each is related to B.
Can I do a Cartesian Join Relationship between A and B and then between B and C and get to the data?
0
 
LVL 6

Expert Comment

by:slinkygn
ID: 40499247
Yes, you'll still get all the data that way, but if it's a specific piece of data, it could be that your relationships need to be rethought in the context of what is needed from where.  Again, for that, we would need more info as to how your tables are related to each other and what specific data you need.
0
 

Author Comment

by:maryj152
ID: 40506982
I have some other projects that are taking precedence right now. Can I contact you directly when I get back to the original question or do I need to just submit another question?
0
 
LVL 6

Expert Comment

by:slinkygn
ID: 40531754
I suppose the issue of structuring relationships that we're talking about now is probably a different question, I'd think.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Optimize/Performance Tune Production Databases 11 66
MySQL ERROR 1045 (28000) 2 81
Simple Search Script in FileMaker 4 53
Can i Import Access Table Into Oracle Using Toad 36 179
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question