Hi, I have a simple FM7 db with 1 table (tblTopics). I would like to create a lay-out where I can see only those topics where the field "Organised" has the value "No". "Organised" is a text field.
I tried to solve this problem by creating a table with a global field with the value "no". I matched this field with the "Organised" field using a relationship (=). This doesn't seem to work though. Any suggestions?