Re: Relationship problem when adding records

Giganews Newsgroups
Subject: Re: Relationship problem when adding records
Posted by:  salad (o…
Date: Fri, 04 Aug 2006

Ron wrote:

> Hi All,
> Using Access2000, winXP.
> Table 1 = tblClients displayed on frmClients via qryClients.  2nd table =
> tblInvoices shown on frmInvoices via qryInvoices.  2nd table = tblDetails
> shown on subform(to frmInvoices) sfrmDetails via qryDetails.
> Relationship built between tblClients/tblInvoices/tblDetails by ClientID.
> Relationship between tblInvoices/tblDetails by InvoiceID.  All works fine if
> I input data into frmInvoice first and then sfrmDetails after.  But, if I
> take the defaults of frmInvoice and just want to put in data on sfrmDetails
> first, everything freezes.  Nothing gets added.  InvoiceID and DetailID get
> incremented, but never show up anywhere.  I think it's probably a
> relationship problem.  tblInvoices doesn't get a new record prior to the prg
> trying to store the new record into tblDetails.
> What am I doing wrong?  How can I get the tblInvoice table to add a record
> prior to the first record being added by the subform for tblDetail table so
> it's available for storing that InvoiceID to tblDetail?
> Thanks in advance for any suggestions.
> ron
Well, if the query expects a client, but there is no client ID, that may
be a problem.  You might want to change the query.  Open up the query in
the query builder, dbl-click on the relationship line between Invoice
and Client, and select the option for All Invoices and those in Clients
that match.


In response to

Relationship problem when adding records posted by Ron on Fri, 04 Aug 2006