TechHelp

Complex Linked Combos Upload Images Link
William Kennedy
37 days ago

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!

Scott Axton
36 days ago

Is Cascading what you are looking for?

William Kennedy
36 days ago

Thank you Scott. I think so.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Subscribe to TechHelp
Get notifications when this page is updated