It's my understanding that data can be pulled from more then one table into a query. Say I track baseball daily game results (win, lost, home or away wins, points for & against, etc) all data that can vary. Now within this table when I input every team's home & away game I also need to include the Teams "League" & "Division" which remains the same per team for tracking varies standing queries, ect. So I set up a seperate Table with the Teams (30-Teams) league & division. In a query I joined my Results Table with my Teams Table where by when I enter in a team into a field the accossiate league & divison appears within the query, great! However here's the problem, all of the other fields from the Results Table -- in the query ('W' 'L 'HW' RW' 'PF' 'PA' etc) cannot be edited or no data can be inputted within that query. Suppose I have a field which contains a LeageWin & a DivisionalWin -- everytime a team wins in its League a "1" goes into the 'LeagueWin feild. Likewis with the divison a "1" goes into the 'DivisionWin' field. But, I can do this only in the Results Table which has the teams & the Divison Wins fields, but not the 'League' & the Divisional fields. So if I don't recall every teams divisional I'm prone for big time errors.
Admitting being an amature (or below?) at Access to me it's a win/lose kind of thing. Meaning, you discover one way to cut down your work/make things easier, but then if affects other parts of your database which only tends to create more work, problems, & FRUSTRATIONS!!! But, I will not give up until everyone stops answering me here which I can't see happening.
As always, any help would greatly be apprechiated!