I have a look up column in a table with the fields "Experience level" and "Point Value". I want to store the point value for calculation in a report. I am having trouble, some of the point values are the same (ie Experienced - 50pts; Professional - 50 pts). The lookup wizard says to "choose a field that uniquely identifies the row. Which column in your lookup column contains the value you want to store or use in your database?"
I want to store the point value for later use - but its not unique. Say for instance in my form I choose the "Professional" experience level. When I go to my report I want it to show the text of "Professional" and give me 50 pts when I do my calculation. It gives me my 50 pts, but displays "Experienced" instead of "Professional".
I think its pulling the first 50 pt value record it sees. Is there a way around this? Like maybe an autonumber field or something?
Any help would greatly be appreciated!
I want to store the point value for later use - but its not unique. Say for instance in my form I choose the "Professional" experience level. When I go to my report I want it to show the text of "Professional" and give me 50 pts when I do my calculation. It gives me my 50 pts, but displays "Experienced" instead of "Professional".
I think its pulling the first 50 pt value record it sees. Is there a way around this? Like maybe an autonumber field or something?
Any help would greatly be appreciated!
