Hi Guys,
I have 5 tables companies, branches , divisions , units and
addresses.
I want to store address of all four tables (companies, branches ,
divisions , units) in a single address table.
FOR THIS I TAKE A ACCOUNTID COLUMN IN ADDRESS TABLE AND Make
refrential integrity on it.

But it gives error while I insert the data due to refrential integrity.

Is there any other way to do this . for relationships pls see the
attachemant.

Thanks & Regards,
Uma

Confidential: This electronic message and all contents
contain information from TRANS CONTINENTAL e-SERVICES, PVT LTD . which may be
privileged, confidential or otherwise protected from disclosure. The
information is intended to be for the addressee only. If you are not the
addressee, any disclosure, copy, distribution or use of the contents of this
message is prohibited. If you have received this electronic message in error,
please notify the sender immediately and destroy the original message and all
copies.

MS Sql Server LazyDBA home page