Genius. That seems to work. So the full relational database functionality is there, it’s just a matter of finding the right features to express it. I’m glad to see I can use this technique for report construction too.

This looks like a feature that is already available to me, and I’ve already been using. However, now that I’m trying to enhance my database from a simple flat table to two related tables, I seem to be losing the ability to group by all fields. I can ...