This content has been marked as final. Show 1 reply
FileMaker 'thinks' a little different from SQL.
First question is always context. The context is defined by the active layout. It is connected with a specific table occurrence (box in relationship graph).
From this context ('point of view') you look into the world and see other connected table occurrences (TO's). SQL views (sort of) are constructed as 'data paths' along a chain of TO's.
If your context is BOOKS and you want to see all WORKS with the same work number you connect the TO's via field work number and you can show the result in a portal. If you want to see at the same time all WORKS with the same work number AND author name (*) then you double the TO of WORK and connect BOOKS and WORK2(**) via work number AND author name.
A second portal now can show the result simultaniously.
(*) It would be much better to compare ID_Author than author name of course
(**) Choose a more descriptive name instead of WORK2