Cascading/Relationship Tables

[mjgravina]

Hi everyone, first time poster here. Been stopping by for reference and its been really useful so far.



I have a quick question, the answer for which is probably going to be much simpler than I think it will be.

I am working on a basic set of tables, in order to demonstrate a specific heriarchy. I have the table:

Main Table A: A1, A2, A3, A4

What I cannot accomplish, is to be able to select A1 from that table, and thus invoke the A1 table, which would then show up items like A11,A12,A13 from another table which -for this purpose- I can call A1x.
And Depending on which one of those I choose (Say A13), I can then bring up the items from table A13x, such as A13a, A13b, A13c...

Does it make sense?

Stuck, not sure how to relate tables, and how to make one selection bring up the next specific one. (If I choose A1, then I am shown all A10 table, and when I choose A13 I am shown a13x table...)

Thanks so much for helping me out, I cannot believe I am stuck this way and the Macros are confusing the Access out of me.

[June7]

Do you want cascading (dependent) comboboxes?

Review: http://www.datapigtechnologies.com/f...combobox2.html

[mjgravina]

That's the one. I was just looking around, and realized that in its form view, the tables can display as comboboxes, and with the link you provided I can start playing with the dependencies. Thanks so much for the reply and link!.. Happy first time user over here.