I have managed to automatically assign a unique ID number to related records in different forms (using MaxValHolder). Now I need to combine the related records into one view.
In other words, I want to view all records with the same ID number in one view. Is this possible?
I currently export into Excel and sort by the ID number to stack related records in sequence. It seems too complicated for a fairly simple database function.
Thanks in advance for your help.