Re: Update conditions not working

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Thu, 16 Aug 2007 15:32:29 -0700, FP1 <rrwyatt@xxxxxxxxx> wrote:

I'm trying to sync a form/subform where they are based on a common
key (Appid). The situation is I want users to be able to add records
to the Form table, but only if a corresponding record (Appid) exists
in the child window. (I do a query to only those records which do not
exist in the table to be editted.) This the 'current' attempt.

If the Form's table is related to the Subform's table by Appid in a one to
many relationship, you have a "chicken or egg" problem here! In order for a
record to exist in the chld table, one must already exist in the parent table;
you're saying that in order to add a record to the parent table you must
already have a record in the child table. You can't have it both ways!

Am I misinterpreting the problem?

John W. Vinson [MVP]
.