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

 

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.

 

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, 201510 yr by Kris M

Are you talking about this?

http://www.modularfilemaker.org/module/master-detail/