Jump to content
The ORIGINAL FileMaker Community - Forum - Online Business Apps & Software Forum

Recommended Posts

zabel

Hi everyone.

It’s good to be back. I haven’t been here for so long, my old account didn’t work anymore ;-)

 

I have a sorting problem I just can’t find the solution to.

 

I created a report in list view to track puch time. It display in subsummary a projectID and a workerId.

my problem is when I do a perform find to omit the punchOut time. It also remove all projects that have no punch yet and I need to see them (to punch in).

In details.

 

Client table with :

projectId:

status : “Production” is the sortind field for the projects

 

Punch table with :

cProjectIdfk

workerId

punchIn (time field)

punchOut (time field)

 

Project and Punch tbl have the projectId as relationship

 

Now I created a report starting from the Punch table

subSummary with Client : projectId

subSummary with workerId

 

I sort it with Client : projectId & workerId

 

so far all goes well, all the projects shows and the workers with their punchIn and out are displayed.

 

I need to remove all the empty punchOut from that list

if I use a perform find status = “Production” and omit punchOut [*]

it works for the sort but it also remove my Project with no entry in the punch table.

 

I feel like I should make the sort in the relashionship but nothing works.

Any help would be approciated. Thank you

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Terms of Use