ContributionsMost RecentMost LikesSolutionsButton To View Child Record ReportI would like to add a button that will open a report in a new window, but filtered to show only the related child records. I get that I can embed the report directly (but I need a report formatted slightly differently than the one that's embedded on the parent record). I'm having no luck with writing to write the URL code. Here are the specific table, and report info: Report ID: 5 Table ID:_DBID_PROJECT_DAYS Please help. I feel like I'm loosing my mind. I've tried the formulas given in various other posts, but nothing seems to be working. Thanks! ------------------------------ Tine R ------------------------------ Re: Automatically tie child to parentYes, they all have user accounts No, only for themselves ------------------------------ Tine Ryming ------------------------------ Automatically tie child to parentI have two related tables. Parent: "Employee". Child: "Timesheet". The relationship works fine. The employee can pull up their employee record, hit the "Add Timesheet" button, and everything ties together beautifully. HOWEVER. That's not a user friendly process. Hitting the "Add Timesheet" button from the home page would work. Except, they don't like having to actually select the parent record (despite it filtering the options down to just the employees record). Is there a way to create a button on the home page that will create a new timesheet and automatically select/tie the new timesheet record back to that user's employee record? ------------------------------ Tine Ryming ------------------------------ Summary Report from 2 TablesHi everyone! I hope someone can help me with a problem. Here's my situation: I have a table for each of the following; Projects, Time Entries, Revenue Budgets. Revenue Budgets and Time Entries each have weekly records that tie back to the same Project (aka. Projects is the parent for each of the 2 remaining tables). Is it possible to create a report for a project that would show records from both the child tables, grouped by a given week. E.g. show the Revenue Budget record for WE 2/23 and the Time Entry records for WE 2/23? I appreciate any help you can give! ------------------------------ Tine ------------------------------