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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists