Subform Lookup

  • Thread starter Thread starter ILoveAccess via AccessMonster.com
  • Start date Start date
I

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?
 
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.
 
Back
Top