how can i do this

[mrk73]

i am using office 2007

i have a table called titles that has title of the movie and the another
field called year of movie also another table called actor that has actor
name of the actos and another infos

and third table called title-actor which is junction table of the two
previous tables and has the fields of title,year,actor name year

the title and the year is conectted to titles table and the actor name to
the actor name in actor table

now i have form based on each of the two tables and each one has sub form
whichs based one the junction table


like this

the title form has sub form which has actor name

now when i entered a new actor name in this subform is doesnt accpet it
unless it exists in the original actor table


but when the actor name does exists in the actor table it brings it from
there and put it in the third table with the name of title and year of the
movie that i enetr in the form


what i want is to write a program which will check if the actor name does
exists in actor table and then if it doesnt it will add it there and in the
title-actor (junction table) with the corsponding title name and teh year and
if the actor does exists it will not add it in the actor table but only in
juncion table with the corsponding title and year

of course the actor name is index key so is the title and year combination
in title table

thanks

 

[Allen Browne]

If you want to get an answer from anyone, please do not post multiple
separate messages to lots of groups.

One group is enough. If you must, you can crosspost (multiple newsgroups in
a single post) so at least the discussion does not become fragmented.

If you are get no answer try rephrasing your question, in a way someone else
can understand.

Posting to multiple groups makes some regulars suspicious of whether you are
a troll, and they won't answer.