I want to do something that I believe is pretty simple in Access but I can’t figure out the right way to ask it in Google to figure it out so hopefully someone here can point me in the right direction.
Here is what I want to do:
I have scores for a test. Those raw scores corrorlate to a point table based on Age and Sex. I want to be able to type the score into my databasenad have it read a second table, pull the correct points from that table, and enter them into a field on the score table automatically.
Joey did 55 pushups. Joey is a 19 yr old male. There is a table for “Males under 30 yrs old” that lists the point value for 52-57 pushups as 8.5 pts. When I type in 55 in the pushups field I want it to reach out to the Males Under 30 table and grab the point value for 55 pushups.
This should be easy to do but I can’t figure out how to ask this question in google to start digging.
Any help here?