Subform Lookup

[ILoveAccess via AccessMonster.com]

Hello!

I have two tables:

"tblCompetitors" (primary key "CompetitorName)
"tblAccounts" (primary key "AccountName")

A competitor can have many accounts assigned to it. I need a form that I can
add a competitor, then assign several accounts to it. Would I need a subform?
If so, how do I set it up?

 

[Allen Browne]

You need a 3rd table "tblCompetitorAccount" with 2 fields:
- CompetitorName relates to tblCompetitors.CompetitorName
- AccountName relates to tblAccounts.AccountName

Then create the form bount to tblCompetitor, with a subform bound to
tblCompetitorAccount.