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
      Can you add a rates tbl? It contains: the type of process (Service, Service at Install...), the Process description, the type of rate (flat, hourly, by SQFT), and the amounts paid, according to the building type (what you called here "PayRate" in the Location table) so 3 currency fields: RateLR, RateHR, RateCT (low rise, high rise or custom building/property types).
      Unsure where to add this... does it change anything else?
      • XPS35's avatar
        XPS35
        Iron Contributor
        You stated that “all payrates are pre-defined upon the loacation’s property type”. So that is why I added PayRate to Location. Now it is different?
    • 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!
    • 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.

Resources