Hi
as you may have noticed I am developing a formular.
In this form the user can insert new datasets. This worked really well, until I expanded may primary connection to another table, adresses.
My structure is now:
MAIN table--
|
table MACHINES--
|
table ADRESSES
I actually write only into MAIN table. Since I have added the ADRESSES I can´t write any dataset, he tells me that "the value for the identity column can´t be set as long as IDENTITY_INSERT is set off" The point is I musn´t write anything into ADRESSES.
Since I have added the ADRESSES table I also get two times the security warning when opening the form.
I´m really desperate now, cause everything was so fine and now it seems to become a real problem!!!
Can anyone help me??
Thanks
Millie