I have two forms with each of them possess a subform(Datasheet) .
First Form : Marketing (Invoice)
Second : Industry (Invoice)

First form has one checkbox
Both of the form is exactly identical even the field in it but based on
their own respective table

Question:

How to append recordsets in the subform in first subform to subform of
second form programmtically when i check the checkbox and delete recordsets
if i uncheck the checkbox? (Append query cant help coz key violation in
lookup field)

I want each page in first form for each page in second form.

Any solutions?

Thanks in advance

Kennykee

As I'm reading this you want to Append the Invoice list from Marketing_Table
to the Invoice list in Industry_Table but run into key violations.

I would guess you're getting these because the common field is the Invoice
number and that field is defined as PK/Unique in Idustry_Table???

If that's so:
Have you tried creating the append query with the where clause:

"Where Invoice_Table!Invoice_Number is null"

This will preclude the query from trying to append the already existing
Invoice into the Invoice_Table.

BAC

"kennykee" wrote:

> I have two forms with each of them possess a subform(Datasheet) .
> First Form : Marketing (Invoice)
> Second : Industry (Invoice)
>
> First form has one checkbox
> Both of the form is exactly identical even the field in it but based on
> their own respective table
>
> Question:
>
> How to append recordsets in the subform in first subform to subform of
> second form programmtically when i check the checkbox and delete recordsets
> if i uncheck the checkbox? (Append query cant help coz key violation in
> lookup field)
>
> I want each page in first form for each page in second form.
>
> Any solutions?
>
> Thanks in advance
>
> Kennykee

Thanks BAC
I will try it out
Sorry for the late reply because Internet Service Provider's server down

"BAC" wrote:

> As I'm reading this you want to Append the Invoice list from Marketing_Table
> to the Invoice list in Industry_Table but run into key violations.
>
> I would guess you're getting these because the common field is the Invoice
> number and that field is defined as PK/Unique in Idustry_Table???
>
> If that's so:
> Have you tried creating the append query with the where clause:
>
> "Where Invoice_Table!Invoice_Number is null"
>
> This will preclude the query from trying to append the already existing
> Invoice into the Invoice_Table.
>
> BAC
>
> "kennykee" wrote:
>
> > I have two forms with each of them possess a subform(Datasheet) .
> > First Form : Marketing (Invoice)
> > Second : Industry (Invoice)
> >
> > First form has one checkbox
> > Both of the form is exactly identical even the field in it but based on
> > their own respective table
> >
> > Question:
> >
> > How to append recordsets in the subform in first subform to subform of
> > second form programmtically when i check the checkbox and delete recordsets
> > if i uncheck the checkbox? (Append query cant help coz key violation in
> > lookup field)
> >
> > I want each page in first form for each page in second form.
> >
> > Any solutions?
> >
> > Thanks in advance
> >
> > Kennykee