Results 1 to 9 of 9

Thread: [RESOLVED] [Access SQL] Best way to Save 'Edited' Multi Table records. (Many-to-many)

Threaded View

  1. Dec 11th, 2009, 01:23 PM #1
    rack
    rack is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    Anchorage, Alaska
    Posts
    545

    Resolved [RESOLVED] [Access SQL] Best way to Save 'Edited' Multi Table records. (Many-to-many)

    I have started to run into an issue where I have tables with multipule Many to Many relationships that I need to be able to allow users to edit.

    How do you manage saving the changes to tables like this?

    A user could edit the record and add/remove Individual Sales Items from the Many to Many table.

    Is the best way just to go through each record in the (Many to Many) table that matches the Main SalesRecordID, and if it isn't in the Listview on the form, mark it as deleted (Or delete it), and add any new items?

    Is there any SQL specific tricks/techniques?
    Attached Images Attached Images  
    Please RATE posts, click the RATE button to the left under the Users Name.

    Once your thread has been answered, Please use the Thread Tools and select RESOLVED so everyone knows your question has been answered.

    "As I look past the light, I see the world I wished tonight, never the less, sleep has come, and death shall soon follow..." © 1998 Jeremy J Swartwood
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width