Click here to Skip to main content
16,018,973 members
Search within:


How Do I Insert A Foreign Key Field Id By Accessing Foreign Key Field Name In Primar Table
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
ASP.NET
Hiii..

I insert a record in account table,in account table have a foreign key ownerid of table owner ,at the time to insert a record in account table i will insert ownername in ownername column of account table & i want to insert a ownerid of that ownename into ownerid column of account table
Posted
Add a Solution

1 solution

Such thing is not possible as you need to validate the ownername first whether exist under the owner table or not then we could insert the record(s) with ownerid accordingly.

I would suggest you to go for some stored-procedure & trigger to do so...Please provide more details if you can.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Alter table FOREIGN KEY error
How do I insert values while there's a foreign key
Foreign key constraint to multiple fields
How do I keep repeated foreign key values without having to get rid of the foreign key constraint?
How do I insert a row of values to a table with a composite foreign key that includes the primary key?
Python MYSQL primary key insert as foreign key in table
Sql: how do I add a constraint foreign key
store foreign key ids in another table
how to insert data into table fields by using foreign key in php
Entity framework migration C# GUID foreign keys

Advertise
Privacy
Cookies
Terms of Use
Last Updated 28 Oct 2015
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web02 2.8:2024-07-22:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900