Please help! I'm cannot figure out this out. How do I update information stored on multiple tables? My database is filled with users. Those users have several related tables. For example each user might have a medical record, driving record, or even movies they rented records... I have each of those tables in fields or datagrids in a tab control. 1 control for each related table. What is the best way to save that information when it is edited?
It seems like a waste to save every table if only 1 entry was made. I'm pulling my hair and I need to get this fixed quickly.
I can also use JOINS to make it one big datatable, but saving it to the database then becomes a chore. Any ideas would be appreciated.