Results 1 to 1 of 1
  1. #1
    Join Date
    May 2003
    Costa Rica

    Red face Unanswered: append from a not coincident query

    I have two tables (OPERATION and INFORM). Both of those tables have the common field named OPERATION. The relations between them are OPERATION (one) to INFORM (many), (one to many). It is necesary that all the OPERATION fiels in OPERATION table could have at least one OPERATION field in INFORM, but also that I could delete registers in the table INFORM. With Access assistant I made a query for searching not coincident between those tables in order to obtain the OPERATION fields in OPERATION table that do not exist in OPERATION field in INFORM table. I would like that if there is a non coincidente OPERATION FIELD, it could be append to the INFORM table.
    The other way could be to do not permit to delete at least the first field in INFORM table.

    Can someone help me please.
    Last edited by Manuel Gimenez; 08-06-03 at 18:28.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts