Jump to content

Welcome the ORIGINAL FileMaker Community

Take a moment to join us, no noise, all FileMaker...We Promise

azzawas

Populate a portal with a found set

Recommended Posts

azzawas

Hello there,

Before my brain turns entirely to mush need to ask for some help with a problem I’m having - let me explain.

I have a table called Schedule, and each record within it represents one day. There is a related table on the layout called Schedule_portal which is used to log if an employee has worked that day, so includes the date, employee name, number of hours worked and daily salary.

Then to summarise 1 week of salary entries I’d need to get the child entries from 7 Schedule records, which is where I’ve been having problems. I tried creating a separate TO of Schedule with a cartesian join to Schedule_portal so I can access all records in the portal. In these experiments the Schedule record was only being used as a platform to access the related portal records, and include fields to set the date range which needs to be searched.

I also tried having a separate TO of those tables with a 1 to many relationship but using the same key for all portal records, again with the aim of being able to access all Schedule_portal records from any Schedule record. I played around with multi keys / summary lists to try and do this but couldn’t get it to work, but think maybe this method has legs.

My final goal is basically to populate the portal with a found set of records based on a date range, but I’ve just not been able to accomplish it.   

I’m not locked into any particular way of doing this - if the goal can be accomplished another way I’d be happy to hear it, or if there is a way to do it with the structure above then great.

Thanks

Share this post


Link to post
Share on other sites
Steve Martino

I think your final goal should just be a report based on the date range, shown in a list view (sub-summary report), based on the Schedule_portal TO.  Then this could be accomplished with finds.

Share this post


Link to post
Share on other sites

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