lookup fields with autopopulate
I have a database that has Club Numbers along with the members in each club. What I am trying to do is when they choose the Club Number from a drop down it then goes to the member number field and I can choose the member number associated with that certain club and then it autopopulates the rest of the information in that member record( for example their 20 scores on file). Also there may be duplicate member numbers not in the same club but within the database. So what is happening is when they choose the club it will list the members in that club but the members that are duplicate within the database are listed from the first club in the database and not the actual club it is associated with. I'm hoping I am explaining this well enough. Any help would be appreciated.