Multiple entries in forms

[kingston.andrew]

I have quite a simple database with one table of company names and
one
table of directors names. Each company has multiple directors and
each
director can be a director of multiple companys.

Because this is a many-to-many relationship I created a junction
table
to hold the DirectorID and CompanyID (both primary keys in the
initial
tables) as composite keys.


The problem I am having is that I am trying to create a form listing
all companies where I can select each company and then input (using a
combo box based on Director Names) all the names of the directors for
that company.


I am able to create a form where I can create a new record each time
and reselect the company and choose a different director but because
I'm dealing with a few hundred companies that can get a bit painful
as
I can potentially end up with a few thousand records.


I have tried using a subform for the Driectors but unfortunately
Access doesn't seem to like that either.


I am sure this is possibly a stupidly simple question and I really
hope so!!


Any help will be greatly appreciated. Please let me know if you need
anymore information....


Thanks,

 

[JamesDeckert]

If you make a company form using the wizard and include all fields from the
junction table and the directors table the subform will allow you to enter
the director #(s) for each company. You might want to print out all directors
first with their director numbers. Then when entering you'll input the #. Be
careful that you are inputing the # into the junction table director # field.
In fact it would be best if you went back into design view and removed the
director # field from the director table from the subform. Also remove the
company# field from the subform as it is unneeded.

As to the combo box method I'm not sure about, but I know the method I
described will work.
hth,
James Deckert

 

[kingston.andrew]

Thanks a million James. That worked perfect. I can't believe I didn't
figure it out myself because I came very close but just couldn't crack
it. I even managed to get it working with a combo box showing the
names!

Thanks,
Andrew.