Related tables and form entry

[Guest]

I have an employee database in which I have many tables all related in 1 to 1
relationships by EmpID. When I use the form I have created to enter employee
data about half of the tables will add the new EmpID and the data that I have
entered the other half will not. How do I create a relationship and join to
enforce referntial integrity and add the new employees to the related tables.

Any help you can give is much appriciated. Clearly, my access knowledge is
limited so please keep it simple.

 

[Jeff Boyce]

The first thing I'd ask you to consider is whether the underlying table
structure is well-normalized. There are a couple reasons for using a
collection of 1 to 1 table relationships, but there are a lot more reasons
why this is either unnecessary or not a good idea.

Please provide a bit more description about what kinds of data you are
storing in separated, 1-to-1 tables.

Since everything Access does starts with the data, getting that right is
first, before any discussion of forms...

Regards

Jeff Boyce
Microsoft Office/Access MVP