Trouble designing a form

[Amit]

Hi,

I have an Organization table, and a Program table. There
is many-to-many relatinship between the two, so there is
an Organization-Program table for storing the Organization
ID and the Program ID.

I'm having trouble designing a form to accomplish this.

I'd like to have a form to select the Program ID using a
combo-box, and then select one or more Organizations
associated with it (again, using a combo-box), with the
Program ID remaining the same, and no need to enter/select
the Program ID again. It means that at a time,
Organizations related to only one program will be entered.

TIA.

-Amit

 

[John Vinson]

I'd like to have a form to select the Program ID using a
combo-box, and then select one or more Organizations
associated with it (again, using a combo-box), with the
Program ID remaining the same, and no need to enter/select
the Program ID again.

I'd use a Form based on the Program table (with an unbound combo box
to navigate to the desired organization record - use the combo box
wizard to set this up); on the form, put a Subform based on the
Organizations-Programs table, with a combo box to select the
OrganizationID. If the Subform uses the ProgramID as the master/child
link field it will do what you want.

 

[Amit]

Thanks John.

That worked!

-Amit

-----Original Message-----