ContributionsMost RecentMost LikesSolutionsRe: Use Value in One Record to Determine if Additional Records Appear in ReportThanks Mark, great answer, as always. I don't think my use case warrants putting too much effort into this. I have two reports of related records embedded in a form with custom formulas that calculate the dimensions for ordering an item, based upon the item type. The problem is that the item type isn't on the same record as the dimensions being calculated. Example: REPORT A Record 1 Name = "Item Type" Value = "A" Record 2 Name = "Height" Value = "20" custom formula subtracts 1 from value and displays result Record 3 Name = "Width" Value = "40" custom formula subtracts 1 from value and displays result REPORT B Record 1 Name = "Item Type" Value = "B" Record 2 Name = "Height" Value = "20" custom formula adds 1 to value and displays result Record 3 Name = "Width" Value = "40" custom formula adds 1 to value and displays result The idea was to show only the correct report with its corresponding calculation on the form, and to hide the other report, based upon what was entered in the Value field of Record 1. By 'hide' I mean not show those records, which would result in a costly mistake if those values were used by mistake. My solution was to settle for marking and color coding the reports based upon the value entered in Record 1 so that the user can clearly see which dimensions to use. The incorrect data still appears, but with a bright red "Do not Use" automatically placed at the top of the column. I was thinking a more elegant solution might exist to just not see the incorrect records, but what I have will work. ------------------------------ Royce Patton ------------------------------ Use Value in One Record to Determine if Additional Records Appear in ReportI have a table with records that only contain two fields "Name" and "Value". What I want to do is have a value in one record determine if additional records appear in a report. For example, if "Value" in Record 1 = "Show Additional Records", Records 2 and 3 would appear in the report along with Record 1, otherwise, they would not. I can't figure out how to control what shows in a report based upon a field in one of the individual records. Is this even possible? Any help would be appreciated. ------------------------------ Royce Patton ------------------------------ Re: "New Style"It's horrible, please make it go away. ------------------------------ Royce Patton ------------------------------