Mark is correct about the Child Table. There are two other options to architect the data.
1) Do a reverse relationship based on the Maximum Record ID from the Child Table. This has been the standard QB method for many years.
2) The new Formula Query logic would probably work directly in the report. It is a bit more complicated but I really like doing this as it keeps the rest of the DB cleaner. There are no extra fields that can confuse Users. Pipelines are great. Super powerful. But it is really hard to track down issues with them after the fact. I forget about them and there is now way inside of an application to search that a Pipeline is working against your application.
------------------------------
Don Larson
------------------------------
