Title
Is it possible to create a "view" on a file maker table?
Post
Hi all, I'm new in this forum .... hope to use it in a right way ::smileyhappy:
I have a table with data that contains a field with values 1 or 2. I would like to create a view (just to be clear to have the same that using an SQL command "create view bla bla bla") filter with value = 1 and another view filter with value 2
I do notkonw if it is possible or not
File maker version: 11 Operating system: Win XP/Windows 7
Thanks in advance
Not really a view as in SQL.
you can create a model and filter it to show only 1 or 2.
you can also consider the table occurences in the relationship tab as kind of view... so you could have a globals table with a field only containing value 1 and link your table to it saying 1 = 1
but when you do a model using this table occurence, you must use it in relationship with the global table, like globals is source table for the model and your table is a portal.