I am new using FM 12. I want to create a portal to filter a table using a relationship. The relation has a constant with value 0 and goes to a table field called DeletedFlag (which is 0 in all the records, except the deleted records which have 1). I am doing something wrong in the relation because it does not show in the related tables only it shows in the unrelated table. Please, may somebody tell me what I am doing wrong? Your help is very much appreciated!
Thanks in advance