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 ContributorCan 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?- XPS35Iron ContributorYou 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?
- 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!
- 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