|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Trouble with connecting two table with relationship connection
Hi alll...I have big issue over here....and i seeking help from u all.....well u see I have 2 asp(dreamweaver mx) pages with contained insert data server behaveiour....the problem is the database which connected to these 2 asp pages is contained 2 table which is link relationship....so when try to insert data to the secondary form it came out wit an error stated cannot update or insert data to the table because of contained relationship
|
|
#2
|
|||
|
|||
|
What kind of relationship do you have between the 2 tables?
Later, David Somers |
|
#3
|
|||
|
|||
|
one to many relatiopship(enforce referential Intergrity).....can u help me please
|
|
#4
|
|||
|
|||
|
How do you have them linked (ie. whats your table structure)?
Later, David Somers |
|
#5
|
|||
|
|||
|
Parent to child
|
|
#6
|
|||
|
|||
|
When you go to add the record in the child record, are you including the foreign field(parent info) in the insert statement. It sould like you are either trying to add a record that doesn't have a parent record to correspond to OR you are not including the Parent information when you are trying to create the child (thus creating an enviroment where the parent info doesn't exist).
S- |
|
#7
|
|||
|
|||
|
this my database strucure
Here is my Database structure for the thred "Trouble with connecting two table with relationship connection"
|
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Trouble with connecting two table with relationship connection |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|