rookie needs help with linked field on form

[Conor]

I apologize in advance for the likely simple-minded nature of this question.

I want a simple database to track the English Premier Soccer League. Naturally I have a table "Teams" with team names and a unique autonumber as the key field.

A "Games" table has game number (key field - autonumber), week number, home team number, visitor team number, home points, visitor points.

I want to create a form to enter match results - all of the above from table "Games", and also pull the team names from table "Teams".

I believe I have the table relationships defined correctly. The relationship window auto-created a second version of the "Teams" table ("Teams_1") so that both Home and Visitor team numbers are in a many-to-one relationship between the tables "Games" and "Teams" or "Teams_1".

I tried to use the form wizard, but I keep getting the same team name for both Home and Visitors. If this makes sense to anyone and you know a solution, I would very much appreciate any suggestions. Thanks in advance.

Conor

 

[boblarson]

I tried to use the form wizard, but I keep getting the same team name for both Home and Visitors. If this makes sense to anyone and you know a solution, I would very much appreciate any suggestions.

Sounds like you need to go into the form in design view and change the control's control source to the appropriate field (Home or Visitor) depending on the control in question.

 

[Conor]

I'd like to thank boblarson for his reply, but it did not really help me. I'm not sure I can change the control source, because there is, in fact, only one table field for team name. The problem, I believe, is that I am trying to reference that field with two different team numbers - home and visitors - from a single form. Any other input would be gratefully accepted. Thanks in advance.

Conor

 

[boblarson]

I'd like to thank boblarson for his reply, but it did not really help me. I'm not sure I can change the control source, because there is, in fact, only one table field for team name. The problem, I believe, is that I am trying to reference that field with two different team numbers - home and visitors - from a single form. Any other input would be gratefully accepted. Thanks in advance.

Conor

Yes, you can but it is hard to explain to you. Can you post your database? Here's how:http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[Conor]

boblarson,

Thanks for being interested enough to come back again. I believe the DB is attached. The instructions you sent were very helpful - necessary in fact. FYI, this is a 2007 DB, not 2003. I hope that is not an issue.

As I said, I am a rookie. I understand that I know diddly. Nothing you can say will insult me. I'm just grateful for the help.

Conor