> > I have a report that has a field in a group header that is supposed to show "specification" and "vendor" data from a related table and from a table related to the latter:
> >
> > lvItemData -> Specifications -> Vendors
> >
> > This field concatenates the values of several character variables that are used because the entire formula is too large to fit the field's own "Expression" entry. The header's break expression (which is used in a separate report field in the same header) is showing the correct information from lvItemData, but the calculated expression for specification and vendor information is showing the values from the previous record.
> >
> > If I add a new test field that shows the field value from the "Vendors" table, it is correct, so the pointers are working correctly.
> >
> > I've tried moving the variables above the break expression in the variable list, but the value printed from the original field is still wrong.
> >
> > I know I can edit the definition of lvItemData to incorporate the desired child data, but I seem to be missing something about the order and timing of how variables are calculated, and it would help if I know what that is. Does anyone have any suggestions? Thanks!
>
> Do you have Cathy Pountney's Report Writer book? She talks about this stuff in chapter 8.
>
> Tamar
No, I have "Flying Fox" by Lisa Nicholls.