Add data to two tables from one form

[Ketil S.]

I have two tables:

MOVIES
mid
title
director

DIRECTOR
did
name

Director in the movies table has a one-to-many relation to the director
table.

What I want to do is this:

I want a form where I can add director to the movies from a combo-box (this
is easy, and not a problem) BUT I also want a field where I can add new
directors to the director table if the name is already registred. How do I
solve this?

 

[tina]

see the following link for a solution, though you may want to modify it to
open an "Add Directors" form instead of a recordset, since you'll probably
have at least two fields to be filled in (first name, last name).

http://www.mvps.org/access/forms/frm0015.htm

hth

 

[fredg]

See my comments in line below.

I have two tables:

MOVIES
mid
title
director

DIRECTOR
did
name

Director in the movies table has a one-to-many relation to the director
table.

Isn't the above backwards? The Director table should have a
one-to-many relationship to the Movies table.
One director can have many movies, but a movie has only one director.

What I want to do is this:

I want a form where I can add director to the movies from a combo-box (this
is easy, and not a problem) BUT I also want a field where I can add new
directors to the director table if the name is already registred. How do I
solve this?

What do you mean by 'already registered'?
Do you mean the directors name is already in the Movies table? That is
not the way to do this.
A director should not be in the Movies table unless he is already
first listed in the Director table.

You can either first enter new directors into the Director table, then
use a combo box to enter the director's name (DirectorID) into the
Movies table,
OR...
When entering a new director (not already in the Director table) into
the Movies table using a Combo Box, use the Combo box NotInList event
to add the new director to the Director table. How would depend upon
what other information you are saving about the director in the
Director's table.

You can give
http://www.groups.google.com
a quick search on the "NotInList" event and return several different
methods to add to the Director table.