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