Hi I have two joined tables and I want to update both with one form. Updating the main table is no problem but the second table sometimes has no values to start with. What ever I try I can't updaet the second table Any ideas? Thanks Matt
what are the table structures? Does the 2nd table not have a primary key?
Hi Pig. Sorted the answer I needed to update table one and replace values in table 2. All working swimmingly now! Also helped when I used a more logical primary key! (ie the same one in both tables) Matt
