Forum Discussion

ValMayo's avatar
ValMayo
Copper Contributor
Jul 24, 2023

Relationships and Junction Table to create - Nice Challenge!

Hi!  Intermediate user but this is beyond my pay grade!  Help!  I need help to set up relationships and would like a Junction Table – would make the production of reports much easier.  I would like relationship with Enforce Integrity + Cascade updates… THANK YOU!

    • ValMayo's avatar
      ValMayo
      Copper Contributor
      WOW!!!!! Thank you! Will try it out right now! And let you know.
    • ValMayo's avatar
      ValMayo
      Copper Contributor
      I am unable to duplicate the join types. Plus I am not always sure which one is primary key vs foreign key. Would it be possible for you to send me this DTB? I will add fields and start working with it to test it out. Thank you.
    • ValMayo's avatar
      ValMayo
      Copper Contributor
      Sorry for so many replies! Just to let you know I have succeeded in duplicating it (watch a video on relationships). I will now add data and test. Thanks again!

Resources