Using a bridging table in forms

[Jack]

Greetings all.

I have two tables. tblDisputes and tblAddress.

A dispute can have many addresses associated, but that address can
also be associated with many disputes. So I have of course by the
rules of database design created a bridging table:
tblDisputesAddressBridge.

I have a form where you enter a new dispute and add various
information. The record source of the form is tblDisputes.

I have many addresses that this dispute can be associated with. Some
may already exist, others need to be entered in addition.

How the hell do I do this? I have attempted to use a combobox - but
what do I bind this to to hold the value? If I bind it to the bridging
table it will only fill in one of the keys not the two...

Or do I use a subform somehow?

Some help please guys!

Thanks

 

[Guest]

Hi Jack,

in your situation i choose to use form with subform and combobox in the subform. The (master) form recordsource will be tblDisputes and the subform recordsource will be, your brdiging table, tblDisputesAddressBridge. Link the master- and sub form through 'Link Master/Child Fields' property of the subform. In the subform use a combobox to enter (existing) Address data and trap Not In List event of combobox to add new Address Data.

HTH

----- Jack wrote: -----

Greetings all.

I have two tables. tblDisputes and tblAddress.

A dispute can have many addresses associated, but that address can
also be associated with many disputes. So I have of course by the
rules of database design created a bridging table:
tblDisputesAddressBridge.

I have a form where you enter a new dispute and add various
information. The record source of the form is tblDisputes.

I have many addresses that this dispute can be associated with. Some
may already exist, others need to be entered in addition.

How the hell do I do this? I have attempted to use a combobox - but
what do I bind this to to hold the value? If I bind it to the bridging
table it will only fill in one of the keys not the two...

Or do I use a subform somehow?

Some help please guys!

Thanks