November 4, 200817 yr Newbies Is it possible to filter a portal in Filemaker v5.5. I have a portal based on a date (job date), which shows all of the jobs for that date. Now I want to filter out the jobs which we do in house. These jobs are designated with a check box. If possible what is the best way to do this. Keep in mind I am using FM v5.5. Thanks in advance...
November 4, 200817 yr You need a calculation field on each side of the relationship to concatenate the date and the checkbox. Use these fields as the matchfields for the relationship. Make sure your calculation cannot produce an ambiguous result ( e.g. "123" could be either "1"&"23" or "12"&"3", while "1|23" leaves no doubt).
Create an account or sign in to comment