Having played a bit further, I realise that if I create tables for each level of heading, and base my value lists on these rather than a flat self-join, I can make Find¹ work as I want.
I was trying to avoid this this is supposed to be a stop-gap database while some huge system is being built, and the idea is to keep it as quick and cheap as possible, so the customer can keep data current until it all gets poured into the new system. But going for a flat database was obviously a step too far! - - Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law.
