Ok, I need help. Simple problem, I hope. I have a DB with 2 tables and one form.

Table1:

Member Name, MemberNum(Text as format is A12125)

Table2:

Member Name, MemberNum, Score 1, Score 2, Score 3, Total Score

Form:
From Table2
Member Name, MemberNum, Round 1 Score, Round 2 Score, Round 3 Score, Total Score

A list of members is stored in Table1. From the form I want to be able to enter the member number and have the member name pulled from Table 1 and stored in a new record in Table 2. I would also like to enter the Member name and have it pull the MemberNum. This shouldn't be too hard but I cannot figure this task out. Please help.

LeeN.

Example attached.

Welcome to Utter Access Forums!

You need to normalize you database... Table2 has repeating groups AND a calculated value (TotalScore), it should also store only the MemberID, without the name.

The tables should look similar to this (add fields as needed):

tblTable1
- MemberID [PK] (A#)
- MemberNum (Text)
- MemebrFirstName
- MemberLastName


tblTable2
- ScoreID [PK] (A#)
- MemberID [FK] (Long) -> FK to tblTable1
- Score

Here are some links about normalization that you should read:

Noah's Normalization Link
Jerry's Treatise on Normalization
Jerry's Fully Qualified Naming
Jerry's Glossary
Danny's Reserved Words
Naming Conventions: Hungarian Notation
Normalization tutorials

HTH