Table A with multiple relationships to the Table B

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • (Edited)
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.
Photo of Ahmed Sharifi

Ahmed Sharifi

  • 90 Points 75 badge 2x thumb
  • frustrated

Posted 1 year ago

  • 0
  • 1

Be the first to post a reply!