Hi alll...I have big issue over here....and i seeking help from u all.....well u see I have 2 asp 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

Hi there,

Can you be a bit more specific? Is page 2 inserting data in a table that has a foreign key pointing to the first table? That is, do you need the ID of the record in the first table to successfully insert a record in the second?

If that's the case, you'll need to pass the new ID from the first table over to the second page, for example by using the QueryString. It depends on your setup, database, and other stuff how you can retrieve this new ID, so please elaborate a bit about your situation.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.