ContributionsMost RecentMost LikesSolutionsRe: Relationship fields: StatusHere's a trick I've used many times. First, in the existing Project(parent)-to-Report(child) relationship, create a summary field [Record ID# of latest Report] that finds the max Record ID#. Then create a new "reverse" relationship with Report as parent and Project as child, and use [Record ID# of latest Report] as the reference field. In the reverse relationship, add a lookup field for the Report [Overall Status]. Re: Drill down of summary report shows no records foundYou might check to see whether the field has some extra characters in it... either spaces or non-printing characters at the beginning or end. Re: Multiple conditions formula to generate cost fieldThis can be done in a Case statement. The formula stops when the first match is found. Try something like this: Case(True, [Miles]<=0, 0, [Miles]<=150, 450, [Miles]<=200, 600, 0 ) The last zero is what's returned if nothing else matches. (You didn't specify what should happen if miles > 200.) Re: Lookup fields not populating data using table-to-table relationshipsDid you create the [Business Title] field directly in the Overtime table, or did you bring it in through the table-to-table relationship? If you create it in the Overtime table, it's not linked to anything, but if you add it to the relationship (viewing the relationship, click the "Add Lookup Fields" button at the bottom of the right-hand pane), it appears in the child table and is automatically linked to the related field in the parent table. Re: Passing Data Through Multiple RelationshipsYou might try creating a report field in your Meeting Minutes table. Report fields don't depend on table-to-table relationships and don't have to use the key field in either table. You base the link on the Project ID field, i.e., records in the Discussion Posts table match records in the Meeting Minutes table if Project ID in each one matches the other. (It will make more sense when you're actually setting up the field.) Re: Is there a way to get more that one sort option in a tableYou have to create a different report from the default report, but you don't have to rebuild everything from scratch. In your new report, using the default options will mean that your new report behaves like the default report and that any changes to the default report will be reflected in the new report as well. To use the default options, make sure "Columns to display" = "Default columns," "Filters" = "Show all xxxx," and "Dynamic" filters = "Use the dynamic filters defined in default report settings.Re: Is there a way to get more that one sort option in a tableThe default report allows only one sort criterion, but you can fake it by creating a new report using all of the default options except setting the sort criteria as you want, and then changing the table home page report from "Default report" to your new report. (You change the home page report by clicking "Customize this report" and -- instead of clicking "Edit settings" beside the report name, click the arrows to select a different report.) Re: Grid Edit ReportAre they lookup fields? If so, you can't grid-edit them directly; rather, you have to edit the reference field, so grid-edit presents the reference fields alongside the lookup fields. Re: Key field update in automationI'm seeing the same behavior, although I don't remember ever trying it before, so I don't know if or when it might have changed. Re: Help with Dynamic form rules on show/hide fieldsGlad to help!