Discussions

 View Only
  • 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.


  • 2.  RE: Table A with multiple relationships to the Table B

    Posted 10-17-2019 10:32
    Ahmed,

    I had this issue and solved it this way.

    I created a check box field in TB
    You need good business process rules to make sure that the check box is set for the "one special TB"  for TA only.
    Then you can create a Summary field TA for the MAX RID in TB where the CB is True

    You now have the Record ID in TB for the Special TB

    Your second step above is still requried but you set the Reference Field in the relationship to that Summary Field and you will get a single result.


    ------------------------------
    Don Larson
    ------------------------------