Im working on a somewhat Complex Check Register Database.  Three fields often are linked to each other with default Values.  Payee, Class, Category.
I would like if the Payee field has a [Class] field that uses a unique combo table associated with that [Payee].  I would like if the [Payee] field also has a Category combo table associated with the [Class] field called [Category].
A [Payee] field many have a number of optional Class data selected with the combo.  Once Class data is selected a unique link is established to a combo that selects Category data for that [Payee] and [Class].
Also is there a way to put those selected fields as default values in each field but allow changes.
Example:  A Payee may be assigned any one of multiple Class designations and that Class designation may have one of multiple Categories for that event.
If someone can point me to an expert video that could help me understand how to do this, Thank You!