Prev: Why won't Single take my number?
Next: Tournament Brackets
From: KARL DEWEY on 18 Mar 2010 13:25
What is the error message?

--
Build a little, test a little.


"dynamic dd" wrote:

>
>
> "KARL DEWEY" wrote:
>
> > If your main form has the navigation buttons (arrows and record numbers in
> > the lower left corner) you should be able to click on the right most arrow
> > and add a new record.
> >
> > --
> > Build a little, test a little.
> >
> >
> > "dynamic dd" wrote:
> >
> > > I have Access 2000 on the job.
> > > I have two tables [Inmate Demographics] (CDCR#, Last Name, First Name, and
> > > DOB are the only fields) and [7362 Tracking] with many medical related
> > > fields.
> > >
> > > [Inmate Demo] Primary Key = 'CDCR#'
> > > [7362 Tracking]. No Primary Key
> > >
> > > One [Inmate Demo] to many [7362 Tracking] relationship on 'CDCR#'
> > > Referential Integrity is checked with cascading updates
> > >
> > > I have a form
> > > Inmate Demographics is the main form with Record Source [Inmate Demographics]
> > > 7362 Tracking1 is the sub form with Record Source [7362 Tracking]
> > >
> > > I set this up this way because the user wanted to be able to input the CDCR
> > > number and have the rest of the inmate demographics pulled up (names and
> > > DOB). This feature works as planned however, now I can't add new records on
> > > the Inmate Demo form. Here is the error message I am getting: “The
> > > Microsoft Jet database engine cannot find a record in the table 'Inmate
> > > Demographics' with key matching fields(s) 'CDCR#'. I understand the reason
> > > is that I have not previously entered the data in the table.
> > > How can I get the update done on the Inmate Demographics form? I really am
> > > frustrated and in need of help.
> > >
> > > Karl,
> Thank you for your help. I am able to enter the #,name and DOB on the form
> but it will not update the Inmate Demo form. I just get the error message.
> Dianne
First  |  Prev  | 
Pages: 1 2
Prev: Why won't Single take my number?
Next: Tournament Brackets