Jump to content

Lookup list


Pedro8000

This topic is 3103 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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 by Kris M
Link to comment
Share on other sites

This topic is 3103 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.