Hi all, I have been programming for a while now and have always used a particular method to update sub-records in a data driven application. I know there is a better way and was hoping flexcoders could point me in a solid direction.
Let's say I have a table called "MasterRecords" and one called "SubRecords" - Each record in the SubRecords table has a Foreign Key called MasterRecordsID which ties it to the MasterRecords table. When I do an update I typically go through and delete all instances of SubRecords from that table and then re-insert them. It is a working method, but tends to create load on the database that is not needed. Is there a better way to handle updates of SubRecords?
