AnsweredAssumed Answered

selecting records at opening layout

Question asked by diederiks on Dec 16, 2017
Latest reply on Dec 17, 2017 by philmodjunk

hi all

have been searching through the posts for a while but all seems to get fairly complex and  i dont really understand

most of it.

what i am looking for is this:

when opening a layout i want to perform a filter on my data so that only a selection of the records will show through that layout.

I dont know much about writing scripts but my feeling is it should be a fairly easy thing to do.

someting like select * from table where variable = "value"

but no idea how to do that in filemaker


the idea is: i have a table of plants, and different layouts for each type of plants, so trees have a layout, shrubs have a layout etc.  each layout should filter. for instance the layout TREE should filter all records where planttype = "tree"

and accordingly when i enter a new record in that layout it should set planttype automatically to "tree"


anynone can point me in the right direction?


much thanks ahead