ContributionsMost RecentMost LikesSolutionsHelp using Copy Detail Records to pre-fill dataI have an application with multiple tables to track a number of Projects (master table). Each month, a Project Manager must go in and create a new Update (sub table to Projects) that will be used to populate an Executive Report for each project. Each Update has multiple tables under it (Financials, Timelines, Milestones, etc...). What I'm looking for is when the user Adds and Update to a project, each sub table automatically copies the values from the last update that was submitted for that project. This is because in many cases, most financials or timelines may not change, and I don't want the user to have to start from scratch for each project.Re: Filter a table report based on value in another tablePlease disregard, I figured out I had to change the key in my Resources table to the User and link via the Current User and it worked. Thanks.Re: Filter a table report based on value in another tableA resource is assigned to a single Segment. In my Segments table there is literally only 2 fields, User and Segment.Filter a table report based on value in another tableI've got 2 tables, Projects and Resources. In my projects table I have many fields, of which one is called Segment, which is supposed to identify a market segment with which the project belongs to. In my resources table, I list users and the Segments for which they are responsible. What I'm trying to accomplish is creating a report of Projects where the Current User can only see the projects to which Segment they are assigned in the Resources table. I've tried relating the tables both directions but can't seem to get the filter to show any records, let alone the right ones. I'm trying to avoid setting up multiple roles.