show filtered records in the portal
I am new to the filemaker, and struggling with it!
Here is my question.
I have two table:
Sign_in: PK_Sign_in_ID, FK_User_ID, Sign_in_time, Sign_out_time,Sign_in_date, Sign_out_date;
User: PK_User_ID, User_name, User_photo;
In one layout, i want to use a portal to show all users' name and photo who haven't sign in yet, and use another portal to show all users' name, photo and sign-in time who already signed in.
Is this possible? I tried to use calculation to filter the records, but just a mess.