Repeated data problem

[fateyes]

Hi,

My contacts database has a couple of tables in it - and one company can have many contacts. I spit this information from an original flat (1 table database). Some of the companies kept all the contacts linked, while some kept the same separation. (i.e

Smith Ltd + Joe
Bob
Kevin
(correct)

Jones Ltd + John

Jones Ltd + Pete

Jones Ltd + Sam

(not correct!)


How do i rectify this?

Cheers for any help

P.S

And , I've just realised I have a direct relationship between the two tables (one to many). Should there be a linking table? I guess I will still have to rectify the problem even if i do put a linking table in.

 

[The_Doc_Man]

I answered this same question in the general section.

I'm pretty easy-going about this, but some folks get incensed when you multi-post.

Please don't get into this habit because it is a GOOD way to get yourself ignored.

 

[fateyes]

sorry - i realised that my question was pretty much table specific...

still, i need to rectify the above problem...

 

[Pat Hartman]

As Doc saic, you have answers in another thread.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32654