Million dollar question - Why can't I update my data?
When my query has only two joined tables it can be updated. But I need to add a third table, when I do it locks. Both secondary tables are joined to the primary key of the main table. Is that the problem?? If so, I cannot create a second primary key (or candidate key) because both table need to like to the primary auto-generated key field. Could someone please help me add a third table. Should be noted that these tables are liked to SQL tables and the joins are already created in SQL. They work fine separately but not in one query. What information can I give to help clarify?
Jul 14, 2011 at 12:01 AM