Pedro8000 Posted September 2, 2015 Share Posted September 2, 2015 Hi there I have a single table which lists all of the schools in an area. All I want to do is create a lookup list which brings back all the relevant data against a school when a particular school is selected. I can do this in seconds in access but after two hours trying I give up in filemaker. Can somebody please help as its getting a bit ridiculous for such a simple task. Many thanks Peter Link to comment Share on other sites More sharing options...
comment Posted September 2, 2015 Share Posted September 2, 2015 I am not sure what you mean by a "lookup list". Lookups in Filemaker are accomplished using a relationship. You select the school (for example, by selecting the school's ID from a value list) and use the selected value as the key in a relationship to the Schools table. See here for more: http://www.filemaker.com/help/14/fmp/en/html/relational.12.20.html#1033096 Note that you don't need a lookup to show data from a related record. You can simply place fields from the related table on the layout. Use a lookup only when you need to copy the related data in order to protect it from future modifications to the original record. Link to comment Share on other sites More sharing options...
Kris M Posted September 2, 2015 Share Posted September 2, 2015 (edited) You have to stop thinking like an Access developer and think like a FileMaker developer. The paradigm shift is significant but not insurmountable. The relationship graph is NOT an ERD. You can think of it as a graphical SQL query engine. Table occurrences are NOT the same thing as tables. Context is everything! Layouts are tied to Table Occurrences. A layout can only access data for the TO it is based on AND any data in TO's joined to it in the relationship graph (for the most part). Calculations operate from a context. You should also visit these primers on relationship graph. Google "Approaches to Graph Modeling" and read the PDF by Nightwing Enterprises http://www.soliantconsulting.com/blog/2009/11/tables_table_occurrences_relationships http://www.teamdf.com/weetbicks/138/tips-hints-the-relationship-graph Edited September 2, 2015 by Kris M Link to comment Share on other sites More sharing options...
Steve Martino Posted September 2, 2015 Share Posted September 2, 2015 Are you talking about this? http://www.modularfilemaker.org/module/master-detail/ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3152 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now