Forum Discussion

limewire's avatar
limewire
Helper I
7 years ago
Solved

Relationship problem after appended data

Greetings~   Current situation: I had a nice relationship going between my query and 2 reference queries where I filtered for variables in the same column. This was so that I could create a calulat...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    limewire for everyone else, we added unique key in both the tables by concatenating year & program name columns and relationship become 1 to many and every existing calculation worked as expected. Cheers!!!

     

     

     

parry2k's avatar
parry2k
Super User
7 years ago

limewire Just emailed you to connect when you have time to take a look.

parry2k's avatar
parry2k
Super User
7 years ago

limewire for everyone else, we added unique key in both the tables by concatenating year & program name columns and relationship become 1 to many and every existing calculation worked as expected. Cheers!!!