Splitting tables

[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>

 

[Joe Fallon]

Your clock is off by 3 days.
Some people might suspect you are trying to jump ahead of everyone else in
the newsgroups.

 

[Roy Goldhammer]

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

 

[Roy Goldhammer]

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?