Discussions

Table A with multiple relationships to the Table B

  • 1.  Table A with multiple relationships to the Table B

    Posted 04-11-2018 05:28
    Hello friends, I have a really frustrating matter to deal with below, any help is appreciated.

    Lets say we have two tables: TA and TB.

    TA has many TBs

    So far so good, now the problem is that TA also has one special TB. Lets call this the "Selected TB."

    How can I set this up such that when I select the "Selected TB" it must be a pulldown that is filtered by the list of TB's that are connected to TA.

    The only way I was able to achieve this was through:
    1. creating to relationships where TA was related to many TB AND
    2. creating a relationship where TB was related to many TA
    3. then adjusting the forms.
    I come from an SQL background and this makes me cringe. I even tried to do this with a Many to Many intermediary table but I can not get the pull downs to show the correct data!

    Please help.

    Thank you.