Forum Discussion
ValMayo
Jul 24, 2023Copper Contributor
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 What about
- ValMayoCopper ContributorWOW!!!!! Thank you! Will try it out right now! And let you know.
- ValMayoCopper ContributorI 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.
- XPS35Iron Contributor
- ValMayoCopper ContributorSorry 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!