Splitting tables

  • Thread starter Thread starter Jeff Boyce
  • Start date Start date
J

Jeff Boyce

Roy

Your post said "some of the companies are agents". That doesn't sound like
"agent" is a characteristic of "company", but of some other relationship.
Step back from your current structure and consider the underlying entities
and relationships (see "normalization" -- here's a link:
http://support.microsoft.com) for KB# 100139.

Work through the normalization exercise before deciding where/how to add a
field.

Good luck

Jeff Boyce
<Access MVP>
 
Your clock is off by 3 days.
Some people might suspect you are trying to jump ahead of everyone else in
the newsgroups.
 
Hello there

I have table with companies information

Some of the companies are agents. For agents i need few more fields.

What is better prefformance:

1. Add the fields for the agent to the company table
2. add new table relate to the companies table with the fields for the
agent?

any help would be useful
 
Thankes keff

I thougt that two.

I know the first 3 normilazation rules and all of them are exist on this
structure

Maybe there is problem with the second or the third by the other field on
the companies which calls - CompanyType that can distinguish between agent
and shipper.

What are the 4th and the 5th normilazation rules?
 
Back
Top