Iam new to to VB2005 and i have a problem. I have two tables in Access lets say ServiceReport and one other Tasks. This tables are connected with the primarykey Servicereportid.
Record's
1
2
3
...
100
When i delete the last record (100) from the Servicereport table then start's my problem.
If i try to add a new record in the servicereport the next servicereportid is 101 and that's correct but in VB2005 it gives me Servicereportid=100 (only in the textbox which i have in my screen because i have test and i see that actually it takes the 101 after an exit from the form), and that's it my problem because a have in the same form and the Tasks table. If i try to save both table together i get an error thats say "You cannot add or change a record because a related record is required in table 'ServiceReports'." and thats it correct because the first table ServiceReportID = 101 and in the Tasks Table it try to give the value ServiceReportID = 100 which doesn't exist actually.
Is this a bug or i something that i'm not doing correct
Thank's a lot
Sorry for my very bad english!!
Autonumber field and Master with Detail Table Error ?
Hot Topic
- Install of Visual Basic Express fails
- Read from ini-File: PInvokeStackImbalance
- Modify XML node newbie question
- How do i make a textbox that uses different forecolors?
- datagrid view using loaded dataset
- how do i use a module to return...
- Checking an sql express database for duplicates
- Runtime Error On Delete / Free, only with "/MD" and outside the IDE
- crude benchmarks
- I can't find where to download the registration benefits.
Autonumber field and Master with Detail Table Error ?
Peter Goode
hi,
Is your problem solved
Thank you,
Bhanu.