I did what I could to find a previous question that answers mine but the closest I could come was this bakery example which does a good job getting me almost there.
www .access-programmers.co.uk/forums/showthread.php?t=108048
(sorry about the link format)
The hypothetical in the above post...