Auto Populate of Fields isnt working correctly
I have an application that has all of the club information in it (club number, member number, member info etc.) It has multiple clubs in it and within those clubs it has multiple member number. There are member numbers that are the same within seperate clubs. For example I could have club 0259 and member 7 but also club 0176 has a member 7. What I am wanting to do is on a display_20_scores stateless form I have then choosing the club number from a dropdown, then I have them choosing a member number within that club from the next dropdown. Now what is supposed to happen is for example they choose club 0259 and member 7 it should show the member name and scores associated with that club and member but instead it is showing the correct club number and correct member number but the member info is pulling from the club 0176 instead of 0259 because 0176 is the first club in my database. How can I get it to pull the correct info from the correct club?