shoud i merge 2 different table?

[fucell26]

im using access 2010.

i have 3 tables.

ExContacts = external contact


InContacts = Internal contact
TblCorrespondence = database that contains detailed information for specific letter.
like Ldate, Subject, ReferenceNo, FromWhom, ToWhom, status, type(either Incoming or outgoing)

now my plan is to merge the 2 tables whichd is excontact and incontact into 1 table. because my reason is i might having problem on relationship of table. i want to connect the primary key of contact tables to "ToWhom" and "FromWhom fieldnames. is it a good idea? cause in my report i want to view those letters that was sent by this specific name and recieved by specific name also.

please help.

thanks.

fucell

[orange]

To get a better appreciation of table design, normalization and keys (Primary/Foreign)
see this tutorial. You'll have to work through it, but you will learn. Start with a clear and accurate statement of WHAT you are trying to do.
Good luck.

[ranman256]

How bout 1 table w 2 fields [INTCON], [EXTCON]
that way the person is in there once.

[June7]

How bout 1 table with 1 field for the contact type (internal, external), assuming person cannot be both internal and external. But this might be redundant if you have a CompanyID field. If contact is not with your company then I presume they are external.