I am kinda new to SQL and such and have the following question
I have a table called (customer) which has a custNum column and is a PK
it has a FK relationship to a table called cust_contacts and a column of
custNum. when a user creates an account I generate a custNum and
populate the cust_contacts table but I get a key constraint error
because this table is a FK and not the PK..Should the table that holds
the login information be the PK table?
Thanks
<CF_SIGNATURE
NAME="Douglas L. Brown"
EMAIL="[EMAIL PROTECTED]"
PHONE="714.538.6611"
WEB="http://www.carnivorepc.com";>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
