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 r...
XPS35
Iron Contributor
ValMayo If rates depend on Proces and Location, you should create a rate table with foreign keys to both Proces and Location, and store the rate there.
ValMayo
Jul 27, 2023Copper Contributor
Sounds great! Can you assist me in doing that? It is ONE field in location but THREE fields in rate... really unsure how to do this...