Dec 9 2005, 11:26 PM
Ok, I need help. Simple problem, I hope. I have a DB with 2 tables and one form.
Member Name, MemberNum(Text as format is A12125)
Member Name, MemberNum, Score 1, Score 2, Score 3, Total Score
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.
Dec 10 2005, 12:03 AM
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):
- MemberID [PK] (A#)
- MemberNum (Text)
- ScoreID [PK] (A#)
- MemberID [FK] (Long) -> FK to tblTable1
Here are some links about normalization that you should read:Noah's Normalization LinkJerry's Treatise on NormalizationJerry's Fully Qualified NamingJerry's GlossaryDanny's Reserved WordsNaming Conventions: Hungarian Notation Normalization tutorials