Append Issue with Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create an append query that will append both data in a form
and its subform at the same time.

Database has a quoting function, and an order function, I want to move
quotes into orders when accepted by customer.

Help appreciated
Thanks
David
 
Moving the data is possible for a child record and a main record, but it
sounds like an attribute of the main form, ie "quote" vs "invoice" vs "paid"
etc. . ..

If you insist on "moving" the data, you will need several to do the
following tasks.

1) Add the parent record to the Invoice main table. making a note of the new
PK
2) Add the child record(s) to the Invoice related table using the PK from
above as the FK
3) Delete from the original child Quote records
4) Delete from the original parent Quote records.


Far easier to just have a "status" field on the main record. . .
 
Thank you,

I did just want to change the "status" but my Boss wanted separate tables -
you know what they are like!
 
Back
Top