Key Violations

From: plegouais (plegouais.12zr2k_at_nospam.MSAccessForum.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 05:36:06 -0600

Hello All,

I am having some difficulty with a series of update queries I am trying
to run. Firstly I have a series of "sites" in one table. This is then
related to a table which has a number of "scenarios" for each of the
sites (and then values which relate to each scenario at each site).
e.g.
site 1, scenario 1
site 1, scenario 2
site 2, scenario 1 etc....

I am trying to create an input form for the site data which will then
append the fixed set of scenarios to the scenarios table based on the
site id entered into the form.

The problem I am having is that the new record is not being created in
the site table before the update query is run and therefore there is no
SiteId in the site table for the appended rows to relate to.

Im using a "confirm" button on my input form (which is opened in add
data mode) to run the queries. The idea is that the user enters the
data and then hits the confirm button. This then updates the the
related table.

At what point does the record actually get created in the table? Can I
force this? Seems to me that once this is done I can run my append
queries without getting a key violation.

Many thanks

Phil

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/