Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    San Bernardino, California, USA
    Thanked 0 Times in 0 Posts

    Deleting linked records (XP, 2000)

    I have a main form containing sub forms

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Deleting linked records (XP, 2000)

    This is controlled by the relationships between the tables. In the Relationships window, you can create relationships, and edit existing ones (by double clicking the line between two tables). If you tick the Referential Integrity and Cascading Deletes check boxes, deleting a record in the table on the "one" side will automatically delete all related records in the table on the "many" side. The text in the customary dialog "You are about to delete 37 record(s)" will be modified to reflect this.

    Note: you can only set referential integrity if you have a primary key on the link field in the table on the "one" side.

Posting Permissions

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