Hello every one. In Access database, I have two tables which are connected by One-to-Many relationship. like:. 1 is Projects, 2 is subprojects. I am tryin to enter the data bay sql statement, But i am getting the Key voilation Error. Can anybody tell me what could be the problem. Thanx
Key violation in Access tables
Collapse
X
-
Tags: None
-
-
Could you post the code you're using and could you please include the MetaData for all relevant datasets? Here is an example of how to post table MetaData :
Table Name=tblStudent
Code:[i]Field; Type; IndexInfo[/i] StudentID; AutoNumber; PK Family; String; FK Name; String University; String; FK Mark; Numeric LastAttendance; Date/Time
Comment
Comment