Multi-Table Form - What is the best way?

[SK]

Greetings,

I am trying to design a multi-table Form in Access 2000.
The two tables in question(Employee and EmployeeMisc)
have a common Key(one-to-one relationship). Basically, I
have the most-oftenly used info in one table and the rest
of it in the other. I want to create a Form which can be
used to:

- Create New Employee Info based on both the tables
- Update existing Employee Info based on both the tables

So far, I have thought of the following:
1. Create a Form using the Wizard and choose both the
tables(and all of their fields). This sets the
Recorsource property to a query based on both the tables
and inherits the table relationship.

2. On the Form, set the Visible property of Employee Code
(and label) for the 2nd table(EmployeeMisc) to False.

3. On the Before Update Event, set the following:
EmployeeCodeOf2ndTable = EmployeeCodeOf1st Table

Is this the best way of achieving what I want to do or
their is another better way? Also, I do not want to
create orphan records(I want to make sure that records in
Employee table can exist even though they maynot exist in
the 2nd table and NOT vice-versa).

Please advise.

Thanks in advance,
SK

 

[TC]

Answered elsewhere.

PLEASE DON'T MULTI-POST!

Multi-posting is posting the same question several times to different
newsgroups. The people who reply in one newsgroup, can not see any answers
given in other newsgroups. I just spent some time to answer your question in
the other newsgroup. I would NOT BE HAPPY to find that someone else had
already answered it in THIS newsgroup! That would mean that I had wasted my
time, in giving my answer.

Instead, please CROSS-POST. This means to post the question ONCE, putting
ALL of the desired newsgroups into thr Newsgroups: line. Then, a person
reading your question in one newsgroup, can see any answers that other
people have already given in the other newsgroups.

TC