Joiner table and form

[Darkmatter5]

If I have the following tables:



ConsolidatedAccounts
ID
AccountNumber

IndividualAccounts
ID
AccountNumber

joiner_ConInd
conAccID
indAccID

conAccID has a relationship to ConsolidatedAccounts.ID
indAccID has a relationship to IndividualAccounts.ID

How should I build a form that lets you scroll through consolidated accounts and has a list of individual accounts with checkboxes and lets me place checks next to the individual accounts that are a part of the consolidated account?

Thanks!

[June7]

What is purpose of check box?

[Darkmatter5]

The checkbox says this individual account is joined to the form consolidated account.

[June7]

No it doesn't. They only way to associate records is with PK/FK fields.

Options for data entry/edit form:

1. single form bound to joiner_ConInd with comboboxes to select Consolidated and Individual accounts

2. main form bound to Consolidated and subform bound to joiner_ConInd with combobox to select Individual account

3. main form bound to Individual and subform bound to joiner_ConInd with combobox to select Consolidated account