Linking tables and forms

[Guest]

I have a table that has over 200 fields. With that I made a form (Employee
Manager) that has several tabs for employee information. Also a separate
form (Compensation Manager) that has several tabs to track compensation. My
table won't let me add any more fields to add a separate form for 'employment
history'. I had to create a new table for the new form. My problem is, I
want to connect the the forms, i.e. when I add say the employees name and id
number to the Employee Manager it comes up on the Compensation Manager and I
want some of the same information transfered to the Employment History
Manager. Is there a way to link the tables so that some of the infomation
from one table will show up in a separate form?

 

[Rick Brandt]

I have a table that has over 200 fields. With that I made a form
(Employee Manager) that has several tabs for employee information.
Also a separate form (Compensation Manager) that has several tabs to
track compensation. My table won't let me add any more fields to add
a separate form for 'employment history'. I had to create a new
table for the new form. My problem is, I want to connect the the
forms, i.e. when I add say the employees name and id number to the
Employee Manager it comes up on the Compensation Manager and I want
some of the same information transfered to the Employment History
Manager. Is there a way to link the tables so that some of the
infomation from one table will show up in a separate form?

Your table design is incorrect. It would be VERY unusual for a correctly
structured table to have more than 30 or so fields much less 200. Access is
not a spreadsheet and if you design tables as you would a spreadsheet you
will get nowhere fast.

It is almost a certainty that your single table should be broken up into
several related tables and then you would use forms with subforms to
interface with them. If you post your current table structure I'm sure you
will get plenty of advice on how to change it.

 

[Allen Browne]

I have a table that has over 200 fields.

Whoa! Stop right here. Ann, you *really* need to do some reading on
"normalization" before continuing.

You cannot create a relational database with 200 fields in one table. It's
not going to work well.

Here's a starting point:
Description of database normalization basics in Access 2000
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209534

 

[Guest]

The table has been broken up into several tables and actually the forms are
working off of a query it looks like. It works great and I have had no
problems with it running all this time. I just want to add more fields to
the main table instead of one of the related tables to create another form
and it won't let me.